Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@hjeicho0317 You don't need set analysis here. You can try :
=FirstSortedValue(Price, -TRDate)
@hjeicho0317 You don't need set analysis here. You can try :
=FirstSortedValue(Price, -TRDate)
Thank you Tresesco .
I does not know this function . It is really powerful .
Jay H. Cho