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:

      Pivot.JPG

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

      Capture.JPG