Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

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

Reply
Contributor
Posts: 37

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

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

SAS Super FREQ
Posts: 586

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

Posted in reply to KarunaTiwari

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

Contributor
Posts: 37

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

Posted in reply to Madelyn_SAS

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

SAS Super FREQ
Posts: 586

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

[ Edited ]
Posted in reply to KarunaTiwari

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

 

 

Ask a Question
Discussion stats
  • 3 replies
  • 182 views
  • 2 likes
  • 2 in conversation