topic Re: SAS VA - SUM DISTINCT VALUES in SAS Visual Analytics

SAS VA - SUM DISTINCT VALUES

JulianR — Tue, 09 Jan 2018 11:48:59 GMT

Hi!!

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

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

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:

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!

FredrikE — Wed, 10 Jan 2018 12:44:34 GMT

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

JulianR — Thu, 11 Jan 2018 15:22:23 GMT

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

FredrikE — Fri, 12 Jan 2018 09:06:10 GMT

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

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

I created a new aggregated measure "CU_Total":

and then a new aggregated measure "ratio":

Works?

//Fredrik