← Excel Sales Reporting
Lesson 3 of 4
Build a pivot-style summary
Group by region and product without duplicating totals.
Do the work
- Use two dimensions as the grouping key.
- Keep each region-product group once.
- The source sales are East PEN 6, East PEN 9, East MUG 12, West PEN 3.
See the method
East PEN combines 6 and 9 into 15.
Read every demonstration step
- East PEN combines 6 and 9 into 15.
- East MUG is a separate group.
- West PEN remains 3.
Practice independently
Exercise 1
Report revenue by region and product
Open practice →Exercise 2Separate count from revenue
Open practice →Take it further
A pivot table performs the same group-and-sum operation with a graphical interface.