ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot-Table - subtotals as % (https://www.excelbanter.com/excel-discussion-misc-queries/242916-pivot-table-subtotals-%25.html)

PBcorn

Pivot-Table - subtotals as %
 
Is it possible to have column subtotals as % of the column? There doesn't
seem to be an option to do this which would seem to be a fairly essential
feature? I am right clicking on each column (data categories arranged as
columns), selecting field settings, but the options button is missing.



All times are GMT +1. The time now is 04:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com