0 Replies Latest reply: Mar 17, 2010 11:00 AM by Amir Vastani RSS

    Rolling Average in YTD, MTD, QTD scenario fails

    Amir Vastani

      I am using the expression

      RANGESUM( Before( sum({<YTDFlag={1}>}SalesAmount), 0, 3) )

      My table looks like

      Department YTD PYTD

      d1 xxxx xxxx

      d2 xxxx xxxx


      The pivot table shows only nulls because the before() function fails to retrieve results which makes sense. Is there anyway around it? I tried above and that didn't do anything either.

      Is there any other inter-record function that could make it work in the expression? Thanks for your help folks!