Last post Aug 25, 2016 07:21 AM by Chris Zhao
Aug 24, 2016 09:24 AM|Joydev|LINK
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
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.
Aug 25, 2016 07:21 AM|Chris Zhao|LINK
You might want to calculate the percentage of a group value relative to the complete dataset, so I try to find some articles how to use other built-in functions to perform aggregations. You could visit the link below will give you detailed information regarding