3 Replies Latest reply on May 24, 2012 10:43 AM by Reginald Green

    Reverse Running Total Calculation

    Reginald Green

      Hi Everyone,

       

      I was wondering whether it's possible to do a "Reverse Running Total Calculation"?

       

      Basically what I have is a tabular report consisting of 5 columns; the first column is a date, which is then followed by 2 daily total columns and 2 running total columns - one for each of the daily total columns.

       

      Format of the report is as follows:

       

      Date_Column          Daily_Total_Col_1          Running_Total_1          Daily_Total_Col_2          Running_Total_2

       

      Problem:

       

      I want the data to be listed in descending data order (the easy part). The really tricky part is that I want the table calculations to be listed in descending order; therefore the first row will show the grand total for the table, the 2nd row will show the grand total minus the value in the 1st row, the 3rd will show the grand total minus the 1st + 2nd rows, etc.

       

      Thanks in advance.

       

      R