Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
icreated pivot chart , i am using two dimension category and Month and expression sum(Visit).
i want to calcilate relative % as second expression but in pivot there is no option for realtive calculation
please suggest how to achive this in pivot chart.
category | Month | Visit |
abc | jan | 10 |
abs | jan | 10 |
cds | jan | 10 |
hty | jan | 10 |
asd | jan | 50 |
abc | Feb | 20 |
abs | Feb | 30 |
cds | Feb | 30 |
hty | Feb | 30 |
asd | Feb | 30 |
ghj | Mar | 120 |
jkl | Mar | 80 |
hut | Mar | 430 |
Depending on what you mean by "relative", it may be one of these, or something similar:
sum(Visit)/sum(total Visit)
or
sum(Visit)/sum(total<Month> Visit)
or
sum(Visit)/sum(total<category> Visit)
Regards,
Michael