topic Re: How to add a percentage of total to a list table in sas va? in SAS Visual Analytics

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

KarunaTiwari — Tue, 15 Aug 2017 15:05:03 GMT

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

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

Madelyn_SAS — Tue, 15 Aug 2017 15:27:38 GMT

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

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

KarunaTiwari — Tue, 15 Aug 2017 15:33:24 GMT

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

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

Madelyn_SAS — Tue, 15 Aug 2017 15:54:48 GMT

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