Pivot Chart

[#1]

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

[Anonymous]

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