How to add a percentage of total to a list table in sas va?

[KarunaTiwari]

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,

Karuna

[Madelyn_SAS]

Right-click the column header, select Create and Add. You should see a list of derived items including percent of total

[KarunaTiwari]

@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.

[Madelyn_SAS]

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