Hi all, as above. Pivot table allows "Show values as... % of.. % of parent row total.. % of grand total" etc etc.
For my situation however, none of the excel pivot defined functions work. Anyone has any idea insight on whether pivot table has such a function or vba needs to be used?
I am trying to get B8/B7, B11/B10, B15/B14 etc.... within the pivot table itself. I.e. couple of mouse clicks and this will be completed. Save from manually entering a formula to divied 96/68 (=B8/B7), 1/33 (=B11/B10), I have no idea.
None of the pivot table "show values as.." functions work in this case.
The file link is here - https://docs.google.com/open?id=0BzQ...lNFMGprTFZham8
Thank you all you gurus!
Bookmarks