Forum Discussion
Excel: Pivot Table Totals for Row Items
Is there a way to show the total of row items at the bottom of a pivot table by item.
For example, the pivot table below has the items Bikes and Scooters. I need to show the total
number of Bikes and the total number of Scooters like the results highlighted in orange.
Hopefully without using a formula outside of the pivot table since the number of items can vary.
1 Reply
Pivot tables don't work that way.
You might create a second pivot table to display the totals for bikes and scooters. Place it to the right of the first one.
