Fri 16 Dec 2011, 16:47Delegate Tim said...
Tim has attended:
Excel Advanced course
Pivot Tables
I have a Pivot Table Report with subtotals & a grand total. I want to add a new column that will show for each subtotal, what the % of the grand total it is, and show it beside the subtotal
Wed 21 Dec 2011, 09:48Trainer Anthony said...
RE: Pivot Tables
Hi Tim, thanks for your query. You'll need to create a calculated field to achieve that. Here's a walkthrough (also have a look at calculated items):
http://www.bettersolutions.com/excel/EUA153/ML619214331.htm
Hope this helps,
Anthony
