Sales comparison vs last year

[Quy_Nguyen]

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.

[Neymar_Jr · Accepted solution]

Hi,

Please see if this helps.

Thanks,

RT

[Quy_Nguyen]

Thank you so much for the solution. It's very nice to create the dimension that way.

[Quy_Nguyen]

Rajesh made it happen

[agigliotti]

I saw it, it's by Month Year and not by Date as you requested above.

[Quy_Nguyen]

Have a look at the reply that i marked correct. It's exactly what i want.