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

SAS VA - SUM DISTINCT VALUES

Reply
New Contributor
Posts: 2

SAS VA - SUM DISTINCT VALUES

Hi!!

 

I need your help with a problem. I have a table like this:

 

Captura1.PNG

 

The column of LTR has the same value for each date:

 

Captura2.PNG

I need a crosstable with an agregatted measure and a dinamic slider with the date (so i can't precalculated the sum of ltr) like this:

Captura3.PNG

 

I've been looking for the same problem in other post, but i did not found nothing.

 

I'm using the V7.4 of SAS VA.

Thank you so much!

PROC Star
Posts: 399

Re: SAS VA - SUM DISTINCT VALUES

You should be able to create aggregated measures on category and total level and from them create a new aggregated measure with the division?

//Fredrik

New Contributor
Posts: 2

Re: SAS VA - SUM DISTINCT VALUES


Yes, I need sum the UDS (21 uds) and divide into the sum of ltr (80.577,52).

PROC Star
Posts: 399

Re: SAS VA - SUM DISTINCT VALUES

I tried to do it with the example data set "VA_SAMPLE_ACME_BANK", do I get it right?

image.png

 

If so....this is what I did:

I created a new aggregated measure "CU_Total":

image.png

 

and then a new aggregated measure "ratio":

image.png

 

Works?

//Fredrik

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