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.
