Salesforce Menu

Summary Reports In Salesforce

Introduction to Summery Report:

Summary Reports are type of reports provide a listing of data with groupings as well as sub totals. Use summary reports whenever you want subtotals based on the value of a particular field or when you want to create a hierarchically grouped report, such as sales organized by year and then by quarter as per need.

Example: All Accounts for your organization sub totaled by Type.

Step 1: After login into Salesforce.com, click on Report Tab and the click on New Report button

reports-dashboards

Step 2: Select an object for which you want to create a Report. Here we are selecting Account object and then click Create button.

create-new-report

Step 3: Click on ‘Tabular Format’ and click Summary.

unsaved-report

Step 4: Drag any field from left panel; here we have added Type as Field for grouping and all records are grouped based on Type as below. Finally Click Save.

run-report

Formula Field

Step 1 : Click ‘Add formula

add-formula

Step 2 : Formula screen will open. Populate Name and Formula to sum number of employees and Click OK

summary-formula

Step 3 : Formula field will be created as below.

create-formula

Step 4 : Add Formula field in the report as below . Report will show sum of employee for each group as highlighted below.

sum-employee-report

Bucket Fields

Step 1 : Click ‘Add Bucket Field

add-bucket-field

Step 2 : Select ‘Source Column’ as field to be grouped in buckets. Click ‘New Bucket’ and create two groups.

edit-bucket-field

Step 3 : Move values in these buckets and Click OK

edit-bucket-field-2

Step 4 : Bucket field will be added in report as below

run-report

Subscribe Now