08-15-2017 11:05 AM
I have a list table in which I am showing no of accounts by Geo. Now I also want to show % of accounts by Geo.
How I can do that? I know we can add percentage of Total and Sobtotal in Croos tab. but my requirement is to add a percentage column in the list table.
Thanks in advance,
08-15-2017 11:33 AM
@Madelyn_SASThanks for quick response!!
I am able to see this 'Create and Add' option for measures from the data builder but since my column is an aggregated measure created by me , I am not able to see this option.
08-15-2017 11:54 AM - edited 08-15-2017 11:54 AM
You won't be able to use the built-in Percent of Total feature in SAS Visual Analytics Designer on an aggregated measure. I think you will need to use SAS Visual Data Builder to create new columns. This blog might be helpful:
Need an aggregation of an aggregation? Use Visual Data Builder to pre-aggregate your data