% of Subtotal in Pivot Table

ldarling

New Member
Joined
Jul 23, 2007
Messages
3
Is there a way to change the settings or options in a pivot table to calculate the % of Subtotal. My data is arranged by month for 18 months so I would prefer to do by taking % of Subtotals in the columns

Thanks
[/img]
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,836
Office Version
  1. 2019
Platform
  1. Windows
Hi:
Welcome to the board.

I am sorry but to the best of my knowledge customizing calculations with subtotals is not feasible. You may want to reference data in the pivot table elsewhere on the spreadsheet and perform calculations with "regular" excel formulas...

You may be able to use a page field for analysis - depending on how your dates are structured (if the months are a data item by themselves rather than groups of dates this is easier -- only 18 items). Stick the months in a column field, select the months you want to include or not include, then drage the column field up to the page field area - those months you did not check will be excluded and you can get a percent of column for the subgroup now. You can also do this directly in the page field by right clicking the page field item, and then selecting field settings..., and then using the hide items option. Subtotal hidden page items is an option in table options but it is usually defaulted to No.

Hope this helps...I wish I could offer better advice. Regards.
 

ExcelChampion

Well-known Member
Joined
Aug 12, 2005
Messages
976
Perhaps this won't work, but worth a look...

On the Pivot Table toolbar click the Pivot Table button.

Find and select Formulas.

Find and select Calcualed Field.

Refer to the help files if you need help from there or post back.

HTH!
 

Forum statistics

Threads
1,181,055
Messages
5,927,863
Members
436,573
Latest member
CMR237

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
Top