The `pivot_row`

function allows you to group together all the values of a pivoted row as a list, and then aggregate over that list.

For more on this read about how lists work here.

## How Does it Work?

Let’s see how `pivot_row`

actually works. For example, having this table, we can use this table calculation function:

pivot_row(${product.count})

This will show me a list of all the values in each pivot row, like this:

## Calculating the Row Total Using `pivot_row`

We can then perform calculations on this list.

For example, we can calculate the Row Total of this data using the `pivot_row`

function like this:

`sum(pivot_row(${product.count}))`

This function first grabs the pivot row of `${product.count}`

as a list, and then sums that list together. This results in:

### The world is your oyster!

The `pivot_row`

function can be used to aggregate across any pivoted row. For example, read about how to use pivot_row to calculate a percent of total across rows here.