Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
Please how can I display the last data point of the following expression?
=sum({1<Sale_Date={">=$(=Max(Sale_Date)-12)<=$(=Max(Sale_Date))"},Product={'Product 1'}>} Sales)/
Count({1<Sale_Date={">=$(=Max(Sale_Date)-12)<=$(=Max(Sale_Date))"},Product={'Product 1'}>} Sales)
Regards
How many dimension you are using?
You need to suppress for all the dimension one by one in Dimension tab...
One dimension.
Regards