6 Replies Latest reply: Aug 5, 2016 3:19 AM by arul settu RSS

    Current and Previous Year Sales

    Shazad Nazir

      Hello Experts,

       

      I have created two measures:

      1. RevCurrentYear with the expression:  Sum({<Year={"$(=getfieldselections( Year))"}>} RowTotal )

      2.RevPreviousYear with the expression: Sum({<Year={"$(=getfieldselections( Year)-1)"}>} RowTotal )

       

      The first expression of (RevCurrentYear) works fine but the second one (RevPreviousYear) gives the same result as of RevCurrentYear.

       

      Can you please guide me, what is the problem in second one ?

       

      Thanks & Best Regards,