Accumulated sum to stop at a particular year

[shyamcharan]

Hi,

Can I get help on stopping the accumulated sum in the chart to stop at a particular year.

For example:

Year, Amount, Type

2000, 100, Revenue

2001, 300, Sales

2002, 400, Revenue

2005, 600, Sales

2006, 700, Sales

Now When I accumulate the Amount for Type dimension and Year dimension I get the Accumulations projected till 2006 for 'Revenue'.

But I want the accumulation amount for Revenue Type to stop at 2002 itself as it shows the revenue only till 2002.

Any suggestions would be higly apprecaited.

Regards,

Shyam.

[tresesco]

Try something like:

rangesum (above(Sum(Amount),0,3))