Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
Put the TOTAL also in the Rowno:
Rowno(TOTAL)
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.
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.
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.