1 Reply Latest reply: Feb 13, 2012 10:56 AM by Celambarasan Adhimulam RSS

    Comparison to previous date with date as dimension

      Hello,

       

      Ineed help to include comparisons  to previous weeks into my PivotTable.

      My dimensions is the date and my expression is the sum of a numerical variable for each date.

      I would like to add a second column that contains the sum of the numerical variable for the week before

       

      I.e.,

       

      Date   SUM(variable)   SUM(variable) - 7 d            

       

      2012-02-01   10                 8

      ...

      2012-02-08   12                10

       

      Thanks,David