-
1. Re: Reverse Running Total Calculation
Alex Kerin May 23, 2012 5:09 PM (in response to Reginald Green)Can you provide a tbwx along with the expected result from the data in it?
-
2. Re: Reverse Running Total Calculation
Richard Leeke May 23, 2012 11:31 PM (in response to Alex Kerin)You need to use the Advanced option on the Compute Using to set the order to be used by the table calculation to be the opposite of the order used in the view (by default it will be based on the order of the view).
Like this:
Coffee Sales example attached.
-
Reversed Running Sum.twbx.zip 194.8 KB
-
-
3. Re: Reverse Running Total Calculation
Reginald Green May 24, 2012 10:43 AM (in response to Reginald Green)Hi Alex and Richard,
Thanks for your input, however I answered my own question soon after I posted it.
I sorted the data by date, then created the following calculated field, which I placed next to my daily total column
TOTAL(SUM([Times Launched])) - RUNNING_SUM(SUM([Times Launched]))
As can be seen, the first line shows the cumulative total/grand total, then subsequent lines get closer to zero. Below is a screenshot.
Thanks again
Reginald Green