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

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
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,224,823
Messages
6,181,175
Members
453,021
Latest member
Justyna P

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