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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.arcwise.app/using-arcwise-in-sheets/pivot-tables.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.