hello, how can I realize column the "Reverse Running Total" in cognos analytic? as in attachment
Quote from: lukasz921 on 06 Dec 2018 07:53:03 AM
hello, how can I realize column the "Reverse Running Total" in cognos analytic? as in attachment
Try this expression:
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.
it works :)
thank you very much