Set Analysis with expression having changing value .

[hjeicho0317]

Hello ,

I am trying to use a expression in set analysis .
The expression value is changed by dimension.
I use Sense 2020 Sep. version.

The data to be used is following .

The Data ------------------------------
ItemCode TRDate              Price             Comment ( Not Data ) 
1001           2020/10/01      1,000
1001          2020/10/02       2,000
1001          2020/10/03       3,000          - last Date of  1001 
2001          2020/09/01       3,000
2001          2020/09/10       2,000
2001          2020/09/30       2,500          - last Date  of  2001
3001          2020/05/01       3,000
3001          2020/05/31       2,000          - last Date  of  3001
----------------------------------------------
The chart required is the last TRdate and the last price at last TRDate .

Chart ------------------------------------------------------
ItemCode LastDate           LastDayPrice
1001           2020/10/03      3,000
2001           2020/09/30      2,500
3001           2020/05/31      2,000
--------------------------------------------------------------

The expression for LastDayPrice is difficult to be soloved .
Is it possibe to make a the required chart .

Thanks,

Jay H Cho

[tresesco · Accepted solution]

@hjeicho0317 You don't need set analysis here. You can try :

=FirstSortedValue(Price, -TRDate)

[hjeicho0317]

Thank you Tresesco .   

I does not know  this function .    It is really powerful .  

Jay H. Cho