User575167076 posted
I have a table in below format
criteria Year count
A 2014 6
A 2015 24
B 2014 2
B 2015 72
I have a stacked chart with
values =count
categorygroup=criteria
categorygroup1=year
Now I have to display the data in the chart as percentage.
The percentage should sum upto to 100 for a particular year.
for example for 2014 it should be 6/(2+6) = 75% for criteria A and
2/(2+6) = 25% for criteriaB.
similarly for 2015 it should be 24/(24+72) = 25% for criteria A and
72/(24+72) = 75% for criteriaB.
The number of years is variable but no of criteria is 2(fixed).
This percentage value should be displayed in the bars of column chart.
Please help me to come out of this scenario.
Thanks,
Joy