Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the data sample and expected result like this:
I used:
If(Flag_This_Year = 1, Date) for the dimension,
Sum({<Date ={"$(=AddYears(Max(Date),-1))"}>}Sales) for measure sale last year, but got wrong result.
I know that it can be done with join function in data load script, I am looking for a solution on dashboard.
Any help would be greatly appreciated.
Hi,
Please see if this helps.
Thanks,
RT
Thank you so much for the solution. It's very nice to create the dimension that way.
Rajesh made it happen
I saw it, it's by Month Year and not by Date as you requested above.
Have a look at the reply that i marked correct. It's exactly what i want.