Row subtotal in Excel Pivot

b0unce

Board Regular
Joined
Apr 22, 2009
Messages
75
Hello,

I have this pivot table which has 3 attributes in Row section: Category, country, product.
What I need to do is that in that same Pivot table at the bottom totals appear which show Grand total per selected Row attribute (in this case Country). Now it only shows overall Grand total.
Is it possible to implement, or should I use a separate Pivot table for that?

Thanks!
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
In any case I am missing 1 subtotal, if I drop a filter. Here's the case in more details:
in Rows I have Country, Category, Product group.
Then in totals I can see: by country, by category within the country and by product group within the country and category + grand total.
If I put row attributes Category, Country, Product group, I will be able to see totals by Category, then by country within the category and by product group withing those two + grand total.
But I need a grand total to be visible by each of the Row attributes, i.e. by Country and by Category. I found that I can add Grand total to show several lines like Count, Sum, Average etc., but not how to add additional line with Row attribute.
 
Upvote 0

Forum statistics

Threads
1,213,562
Messages
6,114,322
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top