M
Matt M HMS
Thank you in advance for you effort
Current Pivot Set-up
week
1 2 3 TOTAL
SUBTOTAL %
X Y X Y X Y Total X
Total Y X Y
A) 3 10 5 12 11 25 19
47 * B) 1 9 2 6 8
15 11 30
C) 5 11 5 11 5 11 15
33
SUBTOTAL: 45
110
D) 6 15 8 17 15 30 29
62 #
TOTAL: 74
172
*I would like this percentage to have the following formula:
=19/45
# This percentage should have the following formula:
=29/74
How can I get this to work?
Matt
Current Pivot Set-up
week
1 2 3 TOTAL
SUBTOTAL %
X Y X Y X Y Total X
Total Y X Y
A) 3 10 5 12 11 25 19
47 * B) 1 9 2 6 8
15 11 30
C) 5 11 5 11 5 11 15
33
SUBTOTAL: 45
110
D) 6 15 8 17 15 30 29
62 #
TOTAL: 74
172
*I would like this percentage to have the following formula:
=19/45
# This percentage should have the following formula:
=29/74
How can I get this to work?
Matt