# Pivot Tables

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

1\) Navigate to the [arcwise-connected-data](https://docs.arcwise.app/using-arcwise-in-sheets/arcwise-connected-data "mention") tab you would like to do a pivot on.

<figure><img src="https://803372693-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlIfwCAQgoIa97JJYtlXQ%2Fuploads%2F5u4RR0mMIDBDHu7V3ec8%2FScreenshot%202024-04-02%20at%2010.45.51%20AM.png?alt=media&#x26;token=bc25dff9-2dc7-46de-b1c1-94ef1f4cafeb" 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="https://803372693-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlIfwCAQgoIa97JJYtlXQ%2Fuploads%2Fi2TZl87aiPUrI5O8cTwQ%2FScreenshot%202024-04-02%20at%2010.47.55%20AM.png?alt=media&#x26;token=0d24213d-9212-4894-8bb7-1a68f3e25776" 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="https://803372693-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlIfwCAQgoIa97JJYtlXQ%2Fuploads%2FfbFaZVkdsx5hHeShz8hN%2FScreenshot%202024-04-02%20at%2010.52.37%20AM.png?alt=media&#x26;token=41902d28-61eb-4e40-b372-3f8e2cd167a8" 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.