15 Replies Latest reply: Jan 24, 2018 6:10 AM by Marco Dalla Pozza RSS

    Rangesum question

    Marco Dalla Pozza

      Hi Guys,


      I've got a rangesum function in a pivot table which I can't make it work as I need.

      This is the formula I'm using, it works fine till i keep CalendarYear dimension out of the pivot table, once I put it inside the pivot, the  rolling is interrupted at any new calendar year:


      The January yellow highlighted value should be 47 instead , just as in the following screen shot, with no calendar year