17 Replies Latest reply: Apr 21, 2017 11:02 AM by Sunny Talwar RSS

    RangSum per Year

    Martin Raßloff

      I have the following dimensions year-calendar week.

      Now i want to have a cumulative sum per year.

      But should always start at the beginning of the year.

      This formula does not start at zero at the beginning of the year in an line diagram. in an tabel it is fine.

      I do not find a solution.


      RangeSum(Above(Sum({<TYP={'SALES'}>}PRICE),0,RowNo()))