> 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

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.

<figure><img src="https://2577551913-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MW_FvcY52Jcyt8JHFGs%2Fuploads%2F4ALw3RmzqulCSRUFdkM9%2Ftotal%20row-1.png?alt=media&amp;token=d75e422b-417a-40e2-a42a-b31e059fb12b" 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="https://2577551913-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MW_FvcY52Jcyt8JHFGs%2Fuploads%2FT1JwQXDODjIo8uxXjgRZ%2Ftotal%20row-2.png?alt=media&amp;token=3ebe29b9-404b-482a-8171-3d0caaf70ff8" alt=""><figcaption><p>Configuration of <a href="/cascade/tools/transform/pivot.md">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="https://2577551913-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MW_FvcY52Jcyt8JHFGs%2Fuploads%2FCfPjOteluLoLtODGiKaP%2Ftotal%20row-3.png?alt=media&amp;token=53fd3e53-bc85-42ea-b992-3eaafe799bd7" alt=""><figcaption><p>Connect the two <a href="/cascade/tools/transform/pivot.md">Pivot</a> tools to an <a href="/cascade/tools/combine/append.md">Append</a> tool</p></figcaption></figure>

<figure><img src="https://2577551913-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MW_FvcY52Jcyt8JHFGs%2Fuploads%2FlU4NIJDO5Efe65AH8ttJ%2Ftotal%20row-4.png?alt=media&amp;token=0b5afa27-e89c-4341-8c52-e609fc667f83" alt=""><figcaption><p>Configuration window of the <a href="/cascade/tools/combine/append.md">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="https://2577551913-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MW_FvcY52Jcyt8JHFGs%2Fuploads%2FPafDAAWd9Hf8m2IuBfqd%2Ftotal%20row-5.png?alt=media&amp;token=5374e6f2-eed7-40bf-bf09-485ceca1e6ac" alt=""><figcaption><p>Total row appended to the pivot table</p></figcaption></figure>
