> For the complete documentation index, see [llms.txt](https://docs.cascade.io/cascade/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cascade.io/cascade/cascade-faqs/best-practices/how-to-add-a-total-row-to-a-table.md).

# 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.

<figure><img src="/files/rBWzN1QJdLMBDFEFlRmk" alt=""><figcaption><p>Pivot table in Cascade</p></figcaption></figure>

What we might recommend is using a another [Pivot](/cascade/tools/transform/pivot.md) tool to sum the entire Quantity Ordered and Price Each fields.

<figure><img src="/files/9hmufkqMlgYEwGgPYvLJ" alt=""><figcaption><p>Configuration of <a href="/pages/-MYR3r3o9e06fuhOlQaL">Pivot</a> tool with total value</p></figcaption></figure>

Afterwards, we’d use an [Append](/cascade/tools/combine/append.md) tool to stack the new total record from the second [Pivot](/cascade/tools/transform/pivot.md) tool beneath the first table.

<figure><img src="/files/J7Z23FgP8WpPUUar5ipO" alt=""><figcaption><p>Connect the two <a href="/pages/-MYR3r3o9e06fuhOlQaL">Pivot</a> tools to an <a href="/pages/-MYR5DXVgXDD3zLfPJm2">Append</a> tool</p></figcaption></figure>

<figure><img src="/files/qUuQsz6rIsLHbjujKda8" alt=""><figcaption><p>Configuration window of the <a href="/pages/-MYR5DXVgXDD3zLfPJm2">Append</a> tool</p></figcaption></figure>

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

<figure><img src="/files/hP66v4MQd27AvJhnSwf8" alt=""><figcaption><p>Total row appended to the pivot table</p></figcaption></figure>