I am trying to create a bar chart in SAS visual analytics 7.5 where i am trying to show the distribution of my accounts by a PD bands and customer. I have used the bar chart option in SAS VA and have created a new calculation using the account id count(% of the total). When I am grouping my chart by the customer(used customer as group in roles) it is giving me % by the grand total but i want to see my numbers as % of the column total and not by the Grand total. For demonstration i have pasted the chart that i am getting on SAS VA 7.5. I want my percentages to be shown by each customer as the one in the excel in below picture. can someone help me how do i change this from grand total to row total?
Instead of using a Percent of Total calculation, try assigning your Count measure to the bar chart and set the Group Scale option on the bar chart to Normalize groups to 100%.
I believe this should give you the result you are looking for. Let us know!
You want each bar to show the percent of total for only that category value (X or Y)?
I think what you might want to do is restructure your data so that X and Y are separate columns (as they appear to be in the Excel table?). Then you can calculate Percent of total for each and assign both measures to the bar chart.
Does that make sense? It is possible I am still misunderstanding what you want.
Thanks for the new image!
I still think that restructuring your data so that the X and Y values of Customer are separate variables would be the best approach. When you assign X and Y (or rather, the Percent of Total calculations for those variables) to the bar chart as separate measures, you should get a bar chart very similar to your screenshot.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.