Hi all - looking for a way to create a “running total” calculation in a Table on a Page. Would like to have a basic table where I can Filter and Sort the values in the table, and then calculate a Running Total column that is the Sum of a field for this record, and all those records before it, based on the Filter and Sort.
Assume that the records will be in essentially a random order (not based on order they were added to the table, for instance) and can be Filtered / Sorted differently depending on the standard Table functions.
Currently we solve this by exporting the Filtered / Sorted table values to CSV, importing them to Excel, and then running a quick running total in Excel (which is dead simple for Excel).
Would love to avoid the export to Excel step, and any / all help with this would be most appreciated.