> For the complete documentation index, see [llms.txt](https://docs.arcwise.app/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.arcwise.app/using-arcwise-in-sheets/pivot-tables.md).

# Pivot Tables

Arcwise supports pivots on data tabs. To create a pivot follow the steps below.

1\) Navigate to the [Arcwise Connected Data](/using-arcwise-in-sheets/arcwise-connected-data.md) tab you would like to do a pivot on.

<figure><img src="/files/PI7OFwvs7YN62G8jF9rL" alt="" width="375"><figcaption></figcaption></figure>

2\) From the **Add next step** menu at the bottom left corner select **Add pivot transform**.

<figure><img src="/files/nP9tv4ttteRRVeIcDQNp" alt="" width="375"><figcaption></figcaption></figure>

3\) Add the filters, columns, rows, and value you want in the pivot and **Preview** the result

<figure><img src="/files/SCkhxXslOMnCxfmDsCvv" alt=""><figcaption></figcaption></figure>

4\) When the result looks correct click the green Connect button in the bottom right corner.

### Supported Formulas and Aggregations

Similar to column-level formulas, for pivots we support a subset of the built-in Sheets functions and most common arithmetic expressions. You can also use SQL functions.

#### List of officially supported functions

* **Aggregation functions**
  * SUM
  * COUNT, COUNTUNIQUE
  * AVERAGE
  * MIN, MAX
  * MEDIAN, MODE
  * STDEV, STDEVP
  * VAR, VARP
  * CORREL
  * COVAR, COVARIANCE.P
* **Math functions:** ACOS ASIN ATAN COS COT DEGREES EXP FLOOR LEFT LEN LN LOG LOG10 LOWER MOD PI POWER RADIANS REGEXEXTRACT RIGHT SIGN SIN SQRT TAN TRIM UPPER

#### Examples

* Assuming your table has `cost` and `quantity` columns, the formula `SUM(cost) / SUM(quantity)` would yield the average cost per item.
* Or if you have a table of orders with `price` and `quantity`, `AVERAGE(price * quantity)` would give you the average size of the orders.