Hello everyone,
I am using Web Intelligence.
My requirement is :
The user selects the year 2011,2012 and so on as a report level filter and based on that the report is displayed.
Value in January should be January value + December value from previous year,After this the December value should be hidden.
For this I am using running sum : RunningSum([Amount];Row;([G/L Account - Key]))
But the issue is I get correct result only when I select "All Values" in the report level filer,i.e the December value from 2011 does not get added to January 2012 if I select 2012 in my filter.
Please suggest any alternative way.
Thanks in advance.
Puskar Ghosal