4 Replies Latest reply: Aug 15, 2013 2:04 AM by Ringo Lau RSS

    Rangesum question

    Ringo Lau

      Hi,

       

      I want to create a straight table with an accumulative sold by RangeSum() at season level. Currently I create an expression

       

      rangesum(above (TOTAL sum([sales qty]),0,rowno())) by the accumulative sales breaks at Year level, I tried to put season desciption in the function like this but with no luck, anything is missing?

       

      rangesum(above (TOTAL sum([sales qty]),0,rowno()), [season description])

       

       

       

      sample.jpg