In this Salesforce tutorial, we will learn to Create a Growth Report in Salesforce. We will discuss the method of creating a growth report in both editions of Salesforce i.e. Salesforce Lightning and Salesforce Classic.
Growth Report in Salesforce
In Salesforce Growth Report is a Custom report that is created by selecting the relevant data fields and applying filters to them. A growth report indicates the sales and revenue indexes of an organization. With the help of custom reports like growth reports, it is easy to track data related to sales, opportunities, and revenue.
While working as a System admin for an organization that provides IT solutions and uses Salesforce customer relationship management (CRM) as a primary CRM tool. I was once asked to create a Growth report for the opportunities. The company decided to increase its revenue by the next year and in this situation, it was crucial to create a Growth Report to track opportunities so that the sales team cab stay aligned with revenue goals and make decisions according to that.
In the below step, with the help of an example, I will explain the method of creating a growth report in Salesforce.
Read How to create a Win report in Salesforce
Create a Growth Report in Salesforce Lightning
To create a growth report in Salesforce Lightning, log in to your Salesforce account and follow the steps below.
Step-1: On the Setup page of Salesforce lighting, click on the App Launcher and search for Sales then from the options in the dropdown select Sales.
Step-2: In the Sales application, go to the Reports tab in order to create a growth report.
Step-3: In the Reports window, we can see a list of reports. To create a Growth report click on the button New Report.
Step-4: In this step, we have to select a category for the new report. The growth report is going to be prepared in the data of opportunities, so I’ll select Opportunities under the heading Category on the left sidebar.
After selecting a category, select the report type Opportunities from the list of Report Type Names and then click on the button Start Report that is on the right side of the screen.
Step-5: In the Columns section on the left we can keep or remove the tabs according to the requirements of the growth report. For example, I have kept the tabs Opportunity Name, Fiscal Period, Expected Revenue, and Amount. I have selected the Close Date tab as a group row.
Now, click on the dropdown arrow of the Close Date column and then click on Group Date By. Here, select the group date according to the growth report. For example, I’m creating a monthly growth report so I have selected Calendar Month.
Step-6: After applying these filters to the report, we need to save this report otherwise adding a formula for the growth report won’t work if the report is not saved. To save the report click on the Save button that is on the upper right side.
Step-7: As we click on the Save button a new window will and here we need to enter the details to save this report. Enter the report name in the Report Name field and it will auto-fill the Report Unique Name field. Click on the Save button to apply changes.
Step-8: Go to the Columns section on the left-hand side and there click on the dropdown arrow and from the options in the options in dropdown select Add Summary Formula.
Step-9: In this step, we will add a Growth column that will display the monthly growth percentage with the help of a summary formula. Enter the below details to show the growth percentage column in the report.
- In the Column Name field enter Growth as column name. You can also name it anything like Growth percentage or Monthly Growth.
- Select Formula Output Type as Percent to display growth in percentage.
- In the Decimal Points field, I have selected 0 for the accurate percentage. We can also select the options 1,2,3 etc. to display the percentage in decimal.
- In the text area under the heading General enter the formula.
(AMOUNT:SUM - PREVGROUPVAL (AMOUNT:SUM, CLOSE_DATE)) / PREVGROUPVAL(AMOUNT:SUM, CLOSE_DATE)
Step-10: After entering the formula in the General field, click on the Display tab and activate the radio button Specific Groups and in the Row Group field select Close Date. After making these changes click on the Apply button.
Step-11: As we click on the Apply button, the Growth column will be created but it will not display any data of growth percentage. To show data in the Growth column, click on the Filters tab in the left sidebar.
Step-12: In the Filters tab select All opportunities in the Show Me field. In the Close date select the time period for the data you have to display in the report. For example, I have selected the Close Date as the Current Financial Year.
In the Opportunities Status, I have selected the Closed won opportunities to display in the Growth report data. After applying the filters click on the Refresh button.
Step-13: As we can see after applying filters, the report is displaying growth percentage in the Growth column of the months. Last click on the Save & Run button to save the changes and run the report.
As we click on the Save & Run the report will be saved and it will run in the new window as shown in the picture below.
In this way, we have successfully created a Growth Report in Salesforce Lightning with the help of the steps above.
Read How to create a report for weekly created opportunities in Salesforce
Create a Growth Report in Salesforce Classic
To create a Growth Report in Salesforce Classic, log in to your Salesforce developer account and follow the steps below.
Step-1: On the Home page of Salesforce Classic, click on the Reports tab.
Step-2: In the Reports & Dashboards, click on the New Report button to create a Growth report.
Step-3: In this step, select Opportunities as a report type for the Growth report, and after selecting the report type click on the button Create.
Step-4: To create the growth report from scratch, we have to remove all columns so that we can customize this Growth report from scratch. To remove columns click on the button Remove All Columns.
Step-5: In the Preview section, click on the dropdown of Tabular Format, and from the options select Matrix because we can add the growth percentage formula in Matrix table form only.
Step-6: In this step, we will add columns to the table that are required to create a growth report. To add columns, select the objects from the left-hand side under the heading Opportunity information and drag them to the table region.
In this example, I have added Amount, Expected Revenue, Won, Close date, and Fiscal Period as columns in the table. After adding columns, drag the object Add Formula to the table region.
Step-7: When we drop the Add formula to the table, it will open a new window where we have to add details and formulas for the Growth column.
- In the Column Name field, enter the column name where the growth will display. For example, I have enger Column Name as Growth Percentage.
- In the Format field select Percent and in Decimal Places select 0 for accurate percentages or you can choose 1, 2, or 3 if you have to display the percentage in decimals.
- Activate the radio button At a specific row/column and then in the A option select Close Date and it will autoselect option B as Won.
- In the Formula text area enter the formula:
(AMOUNT:SUM - PREVGROUPVAL (AMOUNT:SUM, CLOSE_DATE)) / PREVGROUPVAL(AMOUNT:SUM, CLOSE_DATE)- Click on the OK button.
Step-8: In this step, we will add filters to display the growth report. Go to the Filters section on the top and in the Show field select All Opportunities. In the Opportunity Status field, select Closed Won and then select Current FY in the Range field.
After applying filters click on the button Run Report.
as we click on Run Report we can see the report is displaying the monthly Growth Percentage as shown in the picture below.
In this way, we have successfully created a Growth Report in Salesforce Classic.
Conclusion
In this Salesforce tutorial, we have learned about creating a Growth Report from scratch in Salesforce Lightning and Salesforce Classic. Along with this we also learned about adding a summary-level formula column to the report in Salesforce. With the help of scenarios and examples that are explained above we get to know about the need to create a Growth report in Salesforce.
You may like to read:
I am Bijay Kumar, the founder of SalesforceFAQs.com. Having over 10 years of experience working in salesforce technologies for clients across the world (Canada, Australia, United States, United Kingdom, New Zealand, etc.). I am a certified salesforce administrator and expert with experience in developing salesforce applications and projects. My goal is to make it easy for people to learn and use salesforce technologies by providing simple and easy-to-understand solutions. Check out the complete profile on About us.