The ParentGroupVal function is one of the lesser known features of Salesforce reporting. In this article you will learn how to create some key metrics for summary reports by using the PARENTGROUPVAL function within a summary, joined or a matrix report. The function obtains the summary value from a parent group, which is a grouping that is a level above the current grouping. The syntax varies based on the report type in context:
Case I:Tracking Lead Source effectiveness
Consider the case where an organization wishes to track the Lead Source effectiveness, and to do that it tags all of its Leads with a Lead Source. If management would like to know the percentage contribution of each lead source towards the total lead count – conceptually you could envision this as a summary report, grouped based on Lead Source. However to get the percentage figure, you would need to divide the count of leads per source, by the total number of leads. In this case, PARENTGROUPVAL would help you get the total number of leads (denominator). Let’s see how:
STEP 1: Construct a summary report based on a Leads report type, grouped by theLead Source field.
STEP 2: Use a custom formula field to extract the percentage contribution of a lead source versus the total lead count.
Now, you have your group level summaries, for instance, you know Lead Source = Web gave you seven leads over the current calendar year. This is where you would use the PARENTGROUPVAL function to obtain the grouping total. Here there is only one level of grouping, so we are simply looking at extracting total from the grand summary level, so your custom formula field definition would look like this:
Note that if you are using point and click to add the PARENTGROUPVAL function from the functions menu, you would get a default syntax like: PARENTGROUPVAL(summary_field, GRAND_SUMMARY).
Here, the ‘summary_field’ is a placeholder that needs to be replaced with the field for which you need the summary. In our case, it is RowCount, which is also a custom field (shown for clarity sake). It should give you a report like this:
STEP 3: Run the report and hid the details to obtain a clean summarized representation of Lead Source effectiveness.
So now we can identify the lead source contribution in quantified terms, we used PARENTGROUPVAL function to obtain the GRAND_SUMMARY;
Similarly, PARENTGROUPVAL function can be used for variety of cases such as:
✓ Monthly Sales Volume ✓ Case Closure per User ✓ Leads Lost Reason ✓ Opportunity Pipeline spread ✓ Etc.
Case II: Obtaining the percentage spread within a subgroup.
For instance, using a summary report to represent the lead source effectiveness by states; in order to find the percentage contribution within a state, we now have to use PARENTGROUPVAL to find the summaries at the state level, and not at a grand summary level.
The formula field established in this case looks as shown below, notice how the PARENTGROUPVAL summary_field is populated to establish the subgroup total. Thanks to the intuitive formula authoring applet, you can construct the PARENTGROUPVAL structure through point and click..
Case III:Usage of PARENTGROUPVAL in a matrix report.
Here, the same metrics are plotted on a matrix report split across calendar months.
The custom formula field setup is shown below:
How have you used the ParentGroupVal function ins reports? Share in the comments below.
What Certification are you studying for now?
Focus on Force currently provides practice exams and study guides for sixteen certifications
He has spent over 10 years working in various Salesforce roles including business analyst, project manager, consultant and solutions architect. Along the way he has earned twelve certifications, published "The Salesforce Career Playbook", and helps Salesforce professionals learn more about Salesforce, develop their career and prepare for certifications.
How to Use the PARENTGROUPVAL functionThe ParentGroupVal function is one of the lesser known features of Salesforce reporting. In this article you will learn how to create some key metrics for summary reports by using the PARENTGROUPVAL function within a summary, joined or a matrix report. The function obtains the summary value from a parent group, which is a grouping that is a level above the current grouping. The syntax… Read More
In the previous article we created a custom account interface by using Visualforce, in this article we’ll extend the functionality by creating a fully custom Opportunity related list. The Opportunity related list will be replaced with a custom table, and it will support: ✓ Pagination ✓ Filtering ✓ Sorting ✓ Quick filtering open Opportunities In order to implement this we need four steps: STEP 1: Create an Apex controller extension… Read More
Although most Salesforce Administrators are quite happy with their job, I’m sure there are a number who have an interest and aspiration to become a Salesforce consultant. Danielle Tonkin is one of those that made the transition from Admin to functional consultant. Here she shares with us what it is like to work as a Salesforce consultant, the challenges, successes and her tips for those interested in following her Salesforce… Read More
Using Visualforce to build a tabbed user interface In this example we will override a standard view with a few lines of Visualforce to build a tabbed interface. Use case: Customize the interface for the Account object using Visualforce tabs. The following tabs should be available: Detail – Display general information about record. Inline edit feature should be supported; Contacts – Related Contacts list should be displayed in this section;… Read More
Global Picklists One of the most voted ideas in the Salesforce IdeaExchange forum was to be able to create a picklist that can be shared across objects. Shared Picklist Idea Salesforce delivered the idea in pilot as of Winter ’16, and is now in Beta for Spring ’16. If you look at the release notes, you would find it by the name ‘Global Picklists”. It is also referred to as… Read More
On December 23 2015, just before the holidays, Salesforce and SteelBrick announced an agreement for Salesforce to acquire Steelbrick for $360 million. Salesforce has a long history of acquiring companies that extend and complement Salesforce functionality and this is in the mid range of the scale, with ExactTarget ($2.5 billion in 2013) and Buddy Media ($745 million in 2012) at the high end and comparable with the more recent purchase… Read More
Process Builder was one of the most awaited features released by Salesforce as an upgrade to the possibilties of the Workflow functionality and as part of its effort to strengthen what can be done declaratively. In Winter 16 Salesforce continues to add further enhancements to the Process Builder. Schedule Multiple Actions Prior to the Winter ’16 release, it was only possible to define 1 scheduled action per criteria node or… Read More
List buttons can be used on list pages, search results and any related list for an object. They allow us to take actions on a group of selected records. In this article we are going to show some examples of how Javascript can be used to work with one or more records in a list view or related list. These are examples for Salesforce Classic, if you want to know… Read More
In the Winter 16 release, Salesforce has introduced a new feature – the Omni-Channel, which is based on a principle of getting work to the right person at the right time. It helps put rules in place to allow the system to determine the importance of work items, and pass it on the right person who is available. Salesforce Omni Channel is built on 4 Functional Blocks: Image Courtesy: Salesforce… Read More
Loops in Visual Workflow Visual Workflow enables many possibilities to automate processes and reduce or eliminate the need for Apex code. One of the key features of Visual Workflow is the ability to process multiple records using a loop construct, unlike standard workflow, where actions such as a field update operate on only one record. Although Process Builder can operate on multiple records to update related records; once the logic… Read More
Manager Group sharing is a little tricky to understand until you see example scenarios. Here we go through a couple of examples to explain how it works. Understanding the Need for Manager Sharing Groups It is a common practice to group users sharing the same business duties under a single Role. For instance, if your organization has 15 territories within a country – and each territory has an Area Sales… Read More
I recently had a chat with Valerio Lancia, a Salesforce CRM Application manager about his journey with Salesforce, what he has learned and his recent certification experience. Q: What is your background? Is it an IT background, or a business background, and how did you first get exposed to Salesforce? A: I have a management engineering degree and my initial job in Italy was as a buyer. After two years… Read More
Once you start working in the Salesforce world, it won’t take long until you come across the need to integrate or connect your Salesforce org to an internal or external system. At that point, you will start to hear about API’s. While you may think that is something that only developers need to know and understand it is useful for anyone working with Salesforce to know what they are and… Read More
When a customer calls and requests support, how does a business know if and what level of service they are entitled to? Or what if service is only provided on certain products? Service could be provided for a certain period (e.g. a warranty) and then a customer must pay for service beyond the warranty period. It could also be that customers can purchase extended warranties or service contracts that may… Read More
Google Tag Manager (GTM) is Google’s free tool for everyone to manage and deploy analytics and marketing tags as well as other code snippets
using an intuitive web UI.
×
Email Notification Settings
Control how you receive company email alerts for credit redemption events.
