8 Replies Latest reply: Feb 12, 2018 6:19 AM by Tresesco B RSS

    MonthYear

    Antonio Forino

      Hi,

      i have as dimension of my data-set the MonthYear

       

      I would like to select 3 Months Nov-2017, Dec-2017, Jan-2018 (expression A) and then based on this selection have the possibility to compare with the same month of the prior year-> Nov-2016, Dec-2016, Jan-2017 (expression B).

       

      Expression A is really simple Sum(Amount)

      How i can build the expression B?

       

      Thank you!