SAS VA - How to create aggregated measure by column value

[HugoVini]

Hello community, I'm having a lot of trouble finding the solution to my problem, I hope you can help me

I have a table that was created from a union, example:

ID    RECEIVED    PAID    REFERENCE

0         100                50                1

1         200                60                1

2         300                70                1

3         400                80                2

4         500                90                2

I'd like to create an aggregated measure that takes all RECEIVED values ​​that have reference equal 1, and another measure for equal reference 2. I've tried several ways to get these measures but I did not succeed.

Thanks in advanced.

[FredrikE · Accepted solution]

Hi!

Two calculated measure might do it?

[measure1]

IF reference = 1 then recieved

ELSE .

[measure2]

IF reference = 2 then recieved

ELSE .

//Fredrik

[HugoVini]

Thanks a lot bro!