See a pivot table like the example here:
http://www.mrexcel.com/tip015.shtml
How would you go about displaying the %'s as a % of the subtotal (see last pivot table).
Eg in West Total it says 79.01%. I want that to read 100% and in the line above appels to be displayed as 64/448 = 14.2% of the West total.
Any help much appreciated!
Regards,
William
http://www.mrexcel.com/tip015.shtml
How would you go about displaying the %'s as a % of the subtotal (see last pivot table).
Eg in West Total it says 79.01%. I want that to read 100% and in the line above appels to be displayed as 64/448 = 14.2% of the West total.
Any help much appreciated!
Regards,
William