Rangesum question

[ringolau]

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

[#2]

Put the TOTAL also in the Rowno:

Rowno(TOTAL)

[ringolau]

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.

[#4]

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.

[ringolau]

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.