Set analysis show value where most recent sale was made

[terezagr]

I am trying to build a set analysis that would give me a value where most recent sale was made.

My data is as following:

Month   Sale    Company

1          0          A

2          10        B

3           3        A

4           5         B

In this case I would like to see the following

Company       Sale

A                     3

B                     5

Any suggestions?

[Gysbert_Wassenaar · Accepted solution]

Use the firstsortedvalue function: firstsortedvalue( Sale, -Month)

[stigchel]

Not sure why you want to use set analysis, for expression with company as dimension you can use

FirstSortedValue(Sale,-Month)

[kavita25]

Check the qvw.

Hope it helps you...

[terezagr]

Brilliant, thank you...not sure why I was immediately thinking about set analysis