Calculating a column total

Hi I’d like to add a summary row as the last row adding up all the values in one column. How do I do that?

Hi @Andrew1 :wave:

The best way to do this is to use a Sum by group step. This will sum all numeric values in a column into a single row. Here’s what my mock data looks like:

After summing the column, it will look like this:

We can then use a Stack tables step to add that row to the bottom of your column as a summary flow.

Here’s what the final flow might look like!

Okay thanks very much!

1 Like