# Create a Pivot Table

### Overview

This procedure generates a pivot table from an existing table based on specified criteria. Using a pivot table is a way to quickly summarize large amounts of data.

### Input Concepts

| Concept                 | Type      | Description                                                                                                              | Default    | Required |
| ----------------------- | --------- | ------------------------------------------------------------------------------------------------------------------------ | ---------- | -------- |
| `table`                 | `table`   | The original table from which the pivot table will be created.                                                           | No default | Yes      |
| `row fields`            | `strings` | The columns to use as the **indexes** of the pivot table.                                                                | No default | Yes      |
| `column field`          | `string`  | The column to use as the **columns** of the pivot table.                                                                 | No default | Yes      |
| `value field`           | `string`  | The column to use as the **values** of the pivot table.                                                                  | No default | Yes      |
| `aggregation function`  | `string`  | The function to aggregate the values in the pivot table. Valid options are `sum`, `mean`, and `count`.                   | No default | Yes      |
| `aggregate column name` | string    | The column name for the aggregated result in columns and row. Specified as: `the aggregate column name is "column name"` | No default | No       |

### Output Concepts

| Concept       | Description                |
| ------------- | -------------------------- |
| `pivot table` | The generated pivot table. |

### Examples

#### 1. Example 1

For example, say we have a table defined in our automation as `the sales data table`.

| Region | Product  | Sales |
| ------ | -------- | ----- |
| North  | Widget A | 100   |
| South  | Widget B | 250   |
| East   | Widget A | 300   |
| West   | Widget B | 450   |

{% tabs %}
{% tab title="Automation" %}

```
the file
open the sales data table at the file
create a pivot table from the sales data table with
  the row fields are "Region"
  the column field is "Product"
  the value field is "Sales"
  the aggregation function is "sum"
  the aggregate column name is "Sales"
```

{% endtab %}

{% tab title="Results" %}

| Region        | Widget A | Widget B | Sales |
| ------------- | -------- | -------- | ----- |
| East          | 300      | 0        | 300   |
| North         | 100      | 0        | 100   |
| South         | 0        | 250      | 250   |
| West          | 0        | 450      | 450   |
| Sales         | 400      | 700      | 1100  |
| {% endtab %}  |          |          |       |
| {% endtabs %} |          |          |       |


---

# 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.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-a-pivot-table.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.