2 Replies Latest reply: Aug 9, 2012 1:52 AM by ramkumar24 RSS

    Expression in Pivot Table

      My Pivot table report is somehow looks like




      To calculate the "Diff " column value I am using the expression

      =if (Count ({$<PeriodName={$(=date(addmonths(PeriodName,-1)))}>} Amount) > 0, 1, 0)


      Returning "1"or "0" just to check that expression is working fine, but its not working. Even though Amount is there for April, its returning "0" for May month.

      Please do suggest where I am doing wrong in expression.