💬How to add a total row to a table

Learn our easiest way to append a Total Row to your table

We went ahead and created a quick pivot table with the sum of ordered products and the sum of the transactional sale price.

Pivot table in Cascade

What we might recommend is using a another Pivot tool to sum the entire Quantity Ordered and Price Each fields.

Configuration of Pivot tool with total value

Afterwards, we’d use an Append tool to stack the new total record from the second Pivot tool beneath the first table.

Connect the two Pivot tools to an Append tool
Configuration window of the Append tool

Feel free to use an Edit Columns tool and Select Columns tool to apply the value ‘Total’ at the bottom of the table.

Total row appended to the pivot table
PreviousBest PracticesNextHow to leave comments on a workflow

Last updated

Was this helpful?