Hi There,
I'm showing the % of subtotal in the Pivot Table. But How do I make the Subtotal appear as a % of itself, and not of the grand total?
Essentially, I want the items in the subtotaled section to be a % of subtotal (which I've done), and the subtotal to show as % of itself (ie:100%) (which I can't seem to do)
Any help will be great. Please ask if you need any further clarification!
Thanks!
I'm showing the % of subtotal in the Pivot Table. But How do I make the Subtotal appear as a % of itself, and not of the grand total?
Essentially, I want the items in the subtotaled section to be a % of subtotal (which I've done), and the subtotal to show as % of itself (ie:100%) (which I can't seem to do)
Any help will be great. Please ask if you need any further clarification!
Thanks!