Reverse Running Total

[lukasz921]

hello, how can I realize column the "Reverse Running Total" in cognos analytic? as in attachment

[Lynn]

hello, how can I realize column the "Reverse Running Total" in cognos analytic? as in attachment

Try this expression:

Code Select Expand


total ( [Flights Count] for report ) - running-total ( [Flights Count] ) - [Flights Count]


This gets the total for the whole report and then subtracts the incremental difference between the running total and the count on each row.

The attached report specification over the sample data illustrates this.

[lukasz921]

it works :)
thank you very much