rangesum expression

[#1]

Hi,

I have a requirement like below

My user wants to selects any month ,it should sum the selected month data and previous months data.

Suppose user selects July month it should display sum (July + all previous months) sales

If he selects November it should display sum ( Nov sales + previous months) sales......and so on......

For this I have used expression like rangesum(above(total sum(sales),0,3))----It will evaluate only 3 months(3 is hard coded) sales.

Which function we should use if user makes dynamic month selections.

Thanks in advance

[venkatg6759 · Accepted solution]

rangesum(above(total sum(sales),0,Rowno(TOTAL)))

[Anonymous]

You use set anlysis instead of rangesum() in this case.  That is, if month is dual, someting like:

sum({<Month={"$(='<=' &num(Month))"}, Year=P(Year) >} Sales