3 Replies Latest reply: Dec 12, 2017 2:56 AM by Lewis Jackson RSS

    Count previous column measure in a Pivot Table

    Lewis Jackson

      Hi!, I'm looking to count the totals of columns by including the previous weeks data as well in a pivot table. Current data looks like this:

      Date2
      Date102/10/201709/10/201723/10/2017
      02/10/20173029
      09/10/2017157
      23/10/201710

       

       

      I want it to look like the following, where it is adding the previous column as well for a running total so to speak:

       

      Date2
      Date102/10/201709/10/201723/10/2017
      02/10/2017303241
      09/10/20171522
      23/10/201710

       

      would someone be able to point me in the right direction for this?

      Cheers