Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Chart

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.

categoryMonthVisit
abcjan10
absjan10
cdsjan10
htyjan10
asdjan50
abcFeb20
absFeb30
cdsFeb30
htyFeb30
asdFeb30
ghjMar120
jklMar80
hutMar430
1 Reply
Anonymous
Not applicable
Author

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