Hi
I have a formula in a sheet that shows a %age of one value against another, when I then create a pivot table showing this %age the sub and grand totals add all these %ages together to give a total.
Is it possible to either:-
a) show these total as %age of the same calculation in my lookup sheet or
b) not show this at all
For example, in the pivot table below I have two lines showing what %age the "Variance" is as a %age of the "Budget", however on the total line it is adding the 31% and the 17% to give 48% but I'd like it to show 26% (£12,897 / £49,628 x 100) or if this isn't possible to not show a total at all for the "Variance %age" column
Area Code Income Budget Variance Variance %age
Aberdeen City 001 £41,513 £31,628 £9,886 31%
Aberdeen City 002 £21,011 £18,000 £3,011 17%
Totals £62,524 £49,628 £12,897 48%
Many thanks
Iain
Bookmarks