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!




      • 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:




      in instead of this (what I want):




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


      Thanks in advance.