Excel Pivot Table: Ask AI in One Line
When this happens
Your sheet has products in column A, regions in column B and sales in column C. You want to see how much each region sold, but the pivot table menus are a maze and you're not sure where to click first. Tell the AI what columns you have and the result you want, and it will walk you through the clicks step by step.
Watch the video
Ask like this
In Excel I have a table with products in column A, regions in column B and sales in column C. I want a pivot table showing total sales by region. Give me step-by-step clicks I can follow.
The answer we got
| 1 | A Product | B Region | C Sales |
|---|---|---|---|
| 2 | Notebook | East | $300 |
| 3 | Pen | West | $120 |
| 4 | Notebook | West | $240 |
| 5 | Folder | East | $180 |
| 6 | Pen | East | $150 |
| 7 | Notebook | East | $210 |
โ The pivot table shows East $840 and West $360, with a grand total of $1,200.
Tips for better results
- Split by product with Columns
To break each region down by product, drag "Product" into the Columns area. If you're unsure which field goes where, just ask the AI.
In the pivot table I just made, I also want to split each region by product. Which field goes in which area? - Need just one region? Use SUMIF
If you only need the East total, a SUMIF formula does it without a pivot table. With the example table, it returns 840.
=SUMIF(B:B,"East",C:C) - Adding rows often? Make it a table first
If you keep adding rows, turn the data into a table first (Insert > Table) and build the pivot table from that. A refresh then picks up new rows automatically.
How do I make my pivot table include new rows automatically when I add them to the data?
Today's checklist
- โ Say what columns your table has
- โกName the result you want (totals by region)
- โขAsk for the clicks step by step
FAQ
It shows Count instead of Sum. Why?
If the Sales column has text or blank cells, Excel may count instead of add. Click the field in Values, open Value Field Settings, choose Sum, and check that the column holds only numbers.
Does this work in Google Sheets?
Yes. In Google Sheets, go to Insert > Pivot table, then add Rows and Values in the editor on the right. Add "in Google Sheets" to your prompt and the AI will use those menu names.
I changed the data but the pivot table didn't update.
Pivot tables don't update on their own. Right-click anywhere in the pivot table and choose Refresh.
More in this category
AI answers can vary by service and version. Double-check anything important before you use it.
Works in ChatGPT, Claude or Gemini.