About kancsw

kancsw · ‎02-06-2022

Hi Sam, if you see the graph attached , this is exactly what I want the VA to do for me, Hopefully this will clear my question.

kancsw · ‎02-02-2022

Sam I think you are misunderstanding my question, I am trying to do a group by customer and do a % of column total like the above excel pivot has done. When I use the % measure as I had shown in my question it is found a %of grand total and not %of column total as you can see in my excel sheet above. I just simply want to change it from being a %of grand total to % of column total

kancsw · ‎02-02-2022

@Sam_SAS - I did change the measure to count and changed the group scale to 100% but it still does not show the right value.

kancsw · ‎02-01-2022

Hi All, 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? ?

Online Status	Offline
Date Last Visited	‎02-09-2022 03:23 AM

Re: % of column total in Bar chart in SAS VA 7.5

Re: % of column total in Bar chart in SAS VA 7.5

Re: % of column total in Bar chart in SAS VA 7.5

% of column total in Bar chart in SAS VA 7.5

Re: % of column total in Bar chart in SAS VA 7.5

Re: % of column total in Bar chart in SAS VA 7.5

Re: % of column total in Bar chart in SAS VA 7.5

% of column total in Bar chart in SAS VA 7.5