ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   % of Running Total to Grand Total in Pivot Table (https://www.excelbanter.com/excel-programming/337555-%25-running-total-grand-total-pivot-table.html)

David

% of Running Total to Grand Total in Pivot Table
 
Thanks to Debra Dalgleish and the http://www.contextures.com/xlPivot10.html
website, I have a pivot table that displays a calculated field to show
RUNNING TOTAL IN.

Is it possible to have a field for the % of the Running Total of the GRAND
TOTAL... ie.. Running total/Grand Total.

Is it possible to use the subtotals and grand totals of your pivot table in
a calculated field within the same pivot table?



All times are GMT +1. The time now is 03:21 PM.

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