Hi, I need to calculate the percentage of a subtotal(column Z) in a pivot table. Bellow is what I want to achieve:
- Sum of the values
- Percentage of the subtotals field 'Z'
Is that possible? Thanks
| |
|
|
|
|
|
|
Output expected |
|
|
| X |
Y |
Z |
A |
Jan |
Feb |
Mar |
Jan |
Feb |
Mar |
| B |
C |
1 |
CH |
20 |
10 |
10 |
40% |
|
|
| |
|
|
US |
30 |
10 |
5 |
60% |
|
|
| |
|
2 |
CH |
20 |
- |
2 |
91% |
|
|
| |
|
|
US |
2 |
2 |
2 |
9% |
|
|
| |
D |
3 |
CH |
0 |
- |
- |
0 |
|
|
| |
|
|
US |
10 |
5 |
5 |
17% |
|
|
| |
|
|
CN |
20 |
10 |
10 |
33% |
|
|
| |
|
|
AB |
30 |
10 |
10 |
50% |
|
|
