14 Replies Latest reply: Jul 2, 2018 10:24 AM by Quy Nguyen RSS

    Sales comparison vs last year

    Quy Nguyen

      Hello,

      I have the data sample and expected result like this:

      1.PNG

      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.