10 Replies Latest reply: Jan 6, 2017 7:11 AM by Sunny Talwar RSS

    Showing only a set of dimension values while using rangesum?

    DIVYA ANAND

      Hi,

       

      I have this table where "rangesum" is summing up the current and previous values in "w/o rangesum".

      I need to find out if it is possible to see only 2016 data on the dimension, but should have the same values in "rangesum" as is now as shown in the second picture?

       

      FYI: the expression behind rangesum is similar to-

      =rangesum(above((Count({<cond1,cond2,cond3>} distinct field)),0,RowNo()))

       

      Does anybody have an idea on this?