# How to add a total row to a table We went ahead and created a quick pivot table with the sum of ordered products and the sum of the transactional sale price.

What we might recommend is using a another [Pivot](https://docs.cascade.io/cascade/tools/transform/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](https://docs.cascade.io/cascade/tools/combine/append) tool to stack the new total record from the second [Pivot](https://docs.cascade.io/cascade/tools/transform/pivot) tool beneath the first table.

Connect the two Pivot tools to an Append tool

Feel free to use an [Edit Columns](https://docs.cascade.io/cascade/tools/transform/editcolumns) tool and [Select Columns](https://docs.cascade.io/cascade/tools/transform/selectcolumns) tool to apply the value ‘Total’ at the bottom of the table.