Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following table:
What I need is to create a table with the last date for each product with the corresponding Sales and Area.
(*) Keep in mind that the last date's value could be NULL. In that case, I should bring the value before that.
Something like this:
Do you know how could I do that?
Note: I need to do it on a chart table with expressions!!!
Thank you!!!
May be this
Dimension
Product
Expression
Year(Date#(Max({<Sales = {'*'}>}Period), 'YYYYMM'))
Month(Date#(Max({<Sales = {'*'}>}Period), 'YYYYMM'))
Max({<Sales = {'*'}>}Period)
FirstSortedValue({<Sales = {'*'}>}Sales, -Period)
FirstSortedValue({<Sales = {'*'}>}Area, -Period)
View solution in original post
What all are your dimensions and what all are the expression? I am assuming Product is the only dimension and rest all as expression?
Yes, that's it.
Anyway, in the end I only need to show:
Product | Sales | Area
With the corresponding last date.
