Visual Analytics - Comparing lines on table

[Rogerio_Alves]

Hi, I'm migrating an excel report to SAS Visual Analytics. On the report there is an KPI that is calculated comparing results using the first line as reference:

price   diff

10       0

20       10

30        20

The challeng is that there are a lot of filters and this first number will change when the filters are used on report.

Thanks!

Rogério

[FredrikE]

Maybe the aggregate function FIRST can help you?

//Fredrik

[Rogerio_Alves]

Thanks to answer!


Will it running inside of VA? Do you have some example?

Thanks.

[FredrikE]

Hi!

This is an example using sashelp.class:

Might help you 🙂

//Fredrik

[Rogerio_Alves · Accepted solution]

Thanks to answer, it works for me!