% of subtotal in pivot table
 

I read the posting on abovementioned in the website and understand this is a
shortfall in excel. I am still not clear how to calculate % of
subtotal(instead of grand total) as the examples shown was for % of grand
total, % of a fixed field but none showing % of subtotal

% of subtotal in pivot table
 

the attached example may help.
regards


+-------------------------------------------------------------------+
|Filename: Book2.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5135 |
+-------------------------------------------------------------------+

--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=566894