Pivot Table Subtotals

Nine Zero

Well-known Member
Joined
Mar 10, 2016
Messages
625
Hello All!

I am trying to organize a pivot table to she me subtotals at the bottom of each "group" and also have a count at the top of each "group"

Example: This is what i would like to achieve

Route 1 Count211222
Store 153015
Store 3401
Store 521552
Store 7458
Route 1 Total71540755323
Route 2 Count322221
Store 25123
Store 41422
Store 611221
Store 811547
Route 2 Total7319423502

<tbody>
</tbody>

Let me know if anyone has any suggestions
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,213,543
Messages
6,114,237
Members
448,555
Latest member
RobertJones1986

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