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

# Rangesum question

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])

• ###### Re: Rangesum question

Put the TOTAL also in the Rowno:

Rowno(TOTAL)

• ###### Re: Rangesum question

Thanks Lous,

Let me make it clear, in the straight table, there will be different brand and season. What I want is to have an accumulated sales grouped by season and brand.

• ###### Re: Rangesum question

I once tried to add a dimension to the TOTAL clause in a Rangesum, this way:

rangesum(above (TOTAL<Brand, Season> sum([sales qty]),0,rowno(TOTAL<Brand, Seaso>)), [season description])

...but it didn´t seem to work. Can't you use a pivot table there? That way yuo can choose to sum the dimensions you want. Thats the way I usually do.

• ###### Re: Rangesum question

My workaround is to combine [year + month] in one dimension and use this

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

Somehow when the date is in more than one dimension, still don't figure out how to do the grouping nicely.