G
Guest
Is it possible to add a calculated field into a Pivot Table where the Calced
field is a percentage of the subtotal for a column. For column A, I have five
values; four of these values are subtotaled to equal 20:
A
2
5
4
9
_
20
12
_
32
How do I add a calculated field (or item) which will show 2/20=10%,
5/20=25%,...and finally 12/32=37.5%
thank you
Matt
field is a percentage of the subtotal for a column. For column A, I have five
values; four of these values are subtotaled to equal 20:
A
2
5
4
9
_
20
12
_
32
How do I add a calculated field (or item) which will show 2/20=10%,
5/20=25%,...and finally 12/32=37.5%
thank you
Matt