5 Replies Latest reply: Apr 28, 2017 9:42 AM by Sunny Talwar RSS

    Accumulating in pivot Table considering not selected dates in filters

    Rubens Rodrigues

      Hi folks,

       

      I have the following scenario:

       

      • Pivot table using accumulating concept: It works!

       

      Accumulation.png

       

      • What am I trying?
        • When selecting 2016 and 2017 periods, I want to consider 2015 in the calculation in order to have the correct accumulated amount. \however, I'm getting this:

       

      Accumulation2.png

       

      in instead of this (what I want):

       

      Accumulation3.png

       

      As I see it, it might be a piece of cake for you experts.

       

      Thanks in advance.

       

      Rubens