Table Formula  Cumulative Quantity by Partition
Can SQL PARTITION BY
translate easily into JavaScript for use in Tables: Apply formulas to columns?
Example SQL PARTITION BY
:
SUM(Quantity) OVER (PARTITION BY Code Column ORDER BY Index Column) AS CUMULATIVE QUANTITY
Based on the example SQL above and dataset image below, here is what we would like the JavaScript table formula to do:
For each matching Code Column row value, output a running total of the quantity associated to the code. Sort the result by the Index column.
SQL PARTITION BY
https://www.sqltutorial.org/sqlwindowfunctions/sqlpartitionby/
Answers

@Jozef_783863 Perhaps this may be feasible if the formula is in an Excel template file, with Excel: Insert a data table into an Excel template? If that approach does not work, I wonder if it may somehow be possible with CSV: Summarize rows with formulas, but I'm not sure what the JavaScript would be.
0 
@Matt_727739, The 7 steps listed below output the following data table (workflow export attached):
 Tables: Add a column  Add sortkey column
 Tables: Apply formulas to columns  Update sortkey column with custom sort values
 Tables: Sort rows  Sort sortkey column
 Excel: Create spreadsheet from data table  Save sorted table to XLSX
 Excel: Convert to CSV  Convert XLSX to CSV
 CSV: Summarize rows with formulas  Javascript to calculate cumulative quantities (see code comments in workflow)
 Tables: Apply formulas to columns  Javascript to update original sorted table (see code comments in workflow)
0