% 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