7 Replies Latest reply: Sep 1, 2016 11:11 AM by Sunny Talwar RSS

    How to subtract day wise count from previous consecutive days

    kapil rathore
      Prod1sept201631aug2016
      30aug2016
      9aug2016
      prod140403532
      prod278707064
      prod34333
      prod414141410
      prod5363040

       

       

      I have a Pivot Table that Show the data Day wise - =Aggr(max(Date(Date#(fetchDate,'YYYYMMDD'),'DD/MMM/YYYY')),fetchDate)

       

      i want to plot another Pivot table that should give the progress day wise (difference between today-yesterday , 31aug-30aug etc,,,) -

       

      Prod

      1sept201631aug201630aug2016
      prod1053
      prod2806
      prod3100
      prod4004
      prod56264

       

      Can you please help how can i achieve this pivot table ?