12-03-2015 05:26 AM
I am trying to create a bar chart in the report using SAS VA and I want to get the percentage of different group within same category. For example, I have group A, B and C. I use Year as category or the x-axis. I try to get the percentage so that if I add up the percentage for A, B and C in the same year it will be 100%. But currently the percentage will be 100% only when I add up the percentage for all the year.
Can someone help me with it? It is quite urgent.
12-03-2015 10:37 AM
12-03-2015 12:40 PM
12-03-2015 12:53 PM - edited 12-03-2015 12:54 PM
The trouble is, the percentages are based on the full data and not the subgroup:
There doesn't seem to be an easy way to get these group subtotals in a barchart.