> For the complete documentation index, see [llms.txt](https://docs.coherent.global/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coherent.global/assistant/agent/workflows/create-and-manage-pivottables.md).

# Create and manage PivotTables

Agent can create, review, refresh, sort, filter, and adjust pivot tables.

Use this workflow when you want an Excel summary that can be refreshed, filtered, and adjusted later. Pivot tables work best when the source range has clear headers and consistent column types.

## When to use this workflow

Use this workflow when you want Agent to summarize structured data in Excel.

Agent can help with:

* Creating a pivot table from a source range.
* Listing existing pivot tables.
* Adding or removing fields.
* Setting filters.
* Sorting and refreshing pivot tables.
* Adjusting the layout.

## Example prompts

* "Create a pivot table from the selected range with Region as rows and Revenue as values."
* "Refresh all pivot tables in this workbook."
* "Filter this pivot table to show only FY2025."
* "Add Product as a column field and sort revenue descending."
* "Inspect this source table and recommend a pivot table layout."

## Recommended steps

1. Select the source range or identify the source sheet and range.
2. Ask Agent to check headers and data types if the source data is unfamiliar.
3. Tell Agent which fields should be rows, columns, values, and filters.
4. Confirm where the pivot table should be created.
5. Review the pivot table and ask Agent to adjust fields if needed.

## Safer pivot table prompts

* "Preview the pivot table layout before creating it."
* "Create the pivot table on a new sheet named `Revenue Pivot`."
* "Do not overwrite existing sheets or ranges."
* "After creating it, summarize which fields were used."

## Tip

If you are unsure which fields to use, ask Agent to inspect the source data and recommend a pivot table layout first.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.coherent.global/assistant/agent/workflows/create-and-manage-pivottables.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.