You can create running totals very easily with a table calculation that will sum the numbers going down the columns. If you switch the sorting, you will still get running totals going downward.
What if you want to sort your data newest to oldest and have the running total calculated bottom to top? You can also do this with table calculations.
Suppose I had a measure called "Flights Count" and wanted to sort by years in descending order.
The reverse running total is created with two table calculations:
- The first is just a normal running total.
-
The second gets the sum of "Flights Count" for the first row, then each subsequent row subtracts the running total from the sum.
