Cummulative Calculation with prompt at report level

[adoremars]

Hi All,

Below is the example on my requirement. Based on the month and balance i need to calculate the trial balance which is cummulative.

Month    Balance   Trial Balance
1   234   234
2   543   777
3   215   992
4   533   1525
5   344   1869

The req is i have month prompt and when i select value 4 the output list should have one row for month 4 with cummulative trial balance as below. What calculation can we do at the report level to get this?

Month    Balance   Trial Balance

4   533   1525


thanks,
Manoj

[blom0344]

Cumulatives are calculated by the Cognos engine, based on the query data fetched. The balance of month 4 is therefore generated by using months 1,2,3 and 4

You can very simply hide the list column bodies based on a boolean variable that checks for :
[month] = 4
Set box type to none for the 'no' value of the variable..