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

    Rolling Average in YTD, MTD, QTD scenario fails

    Amirali 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!