Show Totals, Subtotals and Stacked Summaries
Add a grand total, subtotals per region and two measures in one cell to a Pivot Table, so a pipeline review shows both deal value and deal count.
The pipeline grid shows how much is open per region and stage. The sales manager now wants three more things on the same screen: a subtotal for each region split by business type, the total for the whole team, and the number of deals next to their value, so one large deal does not pass for a busy region.

Before you start
A Pivot Table on open opportunities, grouped by Region and Stage, summing Amount. Show a Pipeline Summary and Drill Into Any Cell builds it.
Steps
Add a second row grouping
Subtotals summarize a group made of smaller groups, so the rows need a second level.
In Data Mappings, under Group Rows, add an item below Region.
Set Field to Type. Turn on Custom Label and enter
Businessas the Label.
The order matters: the first field is the outer group. Region first, then Type, gives one subtotal per region.
Count the deals beside their value
Under Aggregations, add a second item.
Set Field to Opportunity Name and Aggregation to Count: every opportunity has a name, so this counts the deals.
Turn on Custom Label and enter
Dealsas the Label.
Each stage now has two columns side by side, headed Sum Pipeline and Count Deals: the header puts the aggregation before your label.
Troubleshooting
Related tutorials
Show a Pipeline Summary and Drill Into Any Cell: the base grid this tutorial extends.
Group a Pivot Table by Date: closing months or quarters across the top instead of stages.
Export a Pivot Table and Add Header Actions: download the grid with its totals.
Was this helpful?

