Running Total - pick match

[pkelly]

Have created the attached file using pick match functionality.

Want to add a running total column to the right but am unsure of the syntax.

Can anyone help?

[johnw]

Change this part as indicated:

NUM(RANGESUM(SUM(ins_Sales),ABOVE(COLUMN(1))), '#,##0'),
NUM(RANGESUM(SUM(ins_GrossProfit),ABOVE(COLUMN(1))), '#,##0'))

Another approach would be an AsOf table that connects the current period to all previous periods. You might want something like that if you're going to allow pivoting. The other answer would be to turn off pivoting so the user can't mess up the above() function.