The ```
pivot_row
```

table calculation function groups together all the values of a pivoted row as a list.

# How Does It Work?

For example, in the following table, we can use `pivot_row()`

to write this table calculation:

pivot_row(${product.count})

This will display a list of all the values in each pivot row:

## Calculating the Row Total Using ```
pivot_row
```

We can then perform calculations on the previous list; for example, we can calculate the row total of this data using the ```
pivot_row
```

function:

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 ```
pivot_row
```

function can be used to aggregate across any pivoted row. For example, rather than a `sum()`

, we can also calculate the `mean()`

of the values in the list, the `max()`

, the `min()`

, and so on. This section of the Looker Functions and Operators documentation page lists all the available table calculation functions and operators.

We can also perform more complex calculations across pivot rows with the `pivot_row`

function, including a percent of total. Read about how to use pivot_row to calculate a percent of total across rows here .