ChatGPT Prompts for Pivot Tables
20 copy-paste ChatGPT prompts for pivot tables: design, calculated fields, slicers + filters, pivot charts, and the workflows that turn raw data into instant analysis.
In short: This page contains 20 copy-paste ready prompts, organized into 5 categories with a description and pro tip for each. The first 5 prompts are free instantly, no signup needed. Hand-curated and tested by the AI Academy team.
Pivot Design
4 promptsPivot from Question
1/20✨ What it does
ChatGPT designs a pivot table for [analytical question] from [describe columns], naming rows, columns, values with aggregation, filters, and slicers. Fill in your question and columns, then build the pivot that answers the question instead of dumping every column.
Build pivot table for [analytical question]. Data: [describe columns]. Output: rows, columns, values (with aggregation), filters, slicers. Question-first design > data-dump.
Pro tip: Pivot design starts with question, not data. "Sum of revenue by month by region" = clear pivot. "Show me data" = bad pivot. Question first.
Source Data Prep
2/20✨ What it does
ChatGPT tells you how to prep source data for a pivot: headers in row 1, no merged cells, consistent types per column, and no totals sitting in the source. Clean one sheet to that shape, then create the pivot only after those totals are gone.
Prep source data for pivot table. Output: tabular structure (headers in row 1), no merged cells, consistent data types per column, no totals/subtotals in source. Pivot fails on bad source.
Pro tip: Pivots need clean tabular data. Merged cells, multi-level headers, blank rows = pivot breaks. Spend 10 min on source prep; saves 100 min of debugging.
Multi-Level Pivot
3/20✨ What it does
ChatGPT walks through a Year, Quarter, then Month row hierarchy, including expand and collapse, totals at each level, and how drilldown should feel. Drag those three fields in that order, then collapse to Year before you share the workbook.
Multi-level pivot (rows hierarchy: Year → Quarter → Month). Output: drag fields, expand/collapse behavior, totals at each level, design considerations. Hierarchy = drilldown.
Pro tip: Drag time-related fields to rows in hierarchy = automatic group/drill. User expands/collapses. Same pivot, multiple zoom levels. Underused; powerful.
Pivot Refresh Strategy
4/20✨ What it does
ChatGPT plans when to refresh a pivot, manual versus automatic, why a Table as the source is safer, and what stale numbers cost you. Convert the source range to a Table, then refresh before any meeting that uses the figures.
Refresh strategy for pivot. Output: when source changes, manual refresh vs auto, dynamic ranges (table source recommended), consequences of stale pivot. Stale pivot = wrong decisions.
Pro tip: Pivot doesn't auto-refresh on source change. Build pivot from Excel Table = source expands automatically. Right-click → Refresh after data change. Discipline matters.
Prompts get you started. Tutorials level you up.
A growing library of 300+ hands-on AI tutorials. New tutorials added every week.
Calculated Fields + Aggregations
4 promptsCalculated Field
5/20✨ What it does
ChatGPT writes a calculated field such as profit margin, with pivot formula syntax, the field name, where it appears, and when to calculate in the source instead. Add the field to one pivot, then check a sample row by hand before you trust it.
Add calculated field to pivot. Example: profit margin = (revenue - cost) / revenue. Output: formula syntax in pivot, field name, where it appears, alternative (calc in source). Use cases.
Pro tip: Calculated field = derived metric in pivot. Profit margin, growth rate, ratios. Cleaner than calculating in source for analysis-only metrics.
Show Values As — Power
6/20✨ What it does
ChatGPT explains Show Values As options: percent of total, column, row, or parent, difference from the previous period, running total, and rank. Switch one of your value fields to percent of total, then keep raw numbers on a second field if people still want them.
Use "Show Values As" options. Output: % of total, % of column, % of row, % of parent, difference from previous, running total, rank. Built-in calculations underused.
Pro tip: "Show Values As" = built-in advanced calculations. Most users only use "Sum" or "Count." % of total = instant share. Difference from previous = period-over-period. Click and explore.
Multiple Value Fields
7/20✨ What it does
ChatGPT shows how to put several value fields on one pivot, each with its own aggregation and number format, such as revenue, count, and average. Drag your second metric into Values, then format each field so the units are obvious.
Multiple value fields in pivot. Example: revenue + count + average per row. Output: drag multiple to Values, choose aggregation per, formatting per field. Multi-metric pivot.
Pro tip: Single value field = simple metric. Multiple = comprehensive view. Revenue + Count + Avg = volume + frequency + size. One pivot, multi-dimensional view.
Custom Aggregation
8/20✨ What it does
ChatGPT matches Sum, Count, Average, Min, and Max to the question you are asking, and says when you need a calculated field instead. Change the aggregation on one field, then confirm it still answers what you asked.
Custom aggregation in pivot. Default: Sum, Count, Average, Min, Max, etc. Output: when to use each, when calculated field needed instead. Match aggregation to question.
Pro tip: Most pivots use Sum or Count. Min/Max/Average reveal distribution. Different question = different aggregation. "Total revenue" = Sum. "Average deal size" = Average. Match.
Slicers + Filters
4 promptsSlicer Setup
9/20✨ What it does
ChatGPT sets up slicers: which categorical fields should slice, how to lay them out, how to connect several pivots, and light styling. Add one slicer for the field your readers always filter, then connect it to every pivot on the sheet.
Add slicers to pivot. Output: which fields slice (categorical), display layout, multi-pivot connection, slicer styling. Slicers = visual filters.
Pro tip: Slicers > drop-down filters for dashboards. Visual + clickable + multiple-selection. Connect to multiple pivots = dashboard interactivity. Standard for Excel dashboards.
Timeline Slicer
10/20✨ What it does
ChatGPT sets a Timeline slicer on a date-based pivot, with year, quarter, month, or day grain and a clickable range. Enable Timeline on the date field, then pick one quarter before you send the file.
Timeline slicer for date-based pivot. Output: enable, granularity (year/quarter/month/day), connecting to pivot, range selection. Better than date filter for time analysis.
Pro tip: Timeline slicer = visual date range. User drags + sees pivot update. Better UX than date drop-down. Available when pivot has date field.
Filter Strategy
11/20✨ What it does
ChatGPT picks the right pivot filter: a report filter at the top, a slicer, a row or column filter, or a value filter such as Top N. Use a slicer for the field your audience clicks, then save value filters for Top 10 style cuts.
Pivot filter strategy. Output: report filter (top of pivot, single value), slicers (visual), column/row filters (in pivot table), value filters (top N, conditions). Match filter type to need.
Pro tip: Different filter types = different needs. Report filter = single context (e.g., one region). Slicer = interactive multi-select. Value filter = top 10. Combine for sophisticated dashboard.
Top 10 / Bottom 10
12/20✨ What it does
ChatGPT shows how to keep the top 10 or bottom 10 rows, with count versus percent and which value field drives the rank. Apply Top 10 on the metric you care about, then glance at the leftover total so you know what you hid.
Show top 10 rows in pivot. Output: value filter → Top 10, options (top/bottom, count/percent, by which value field), display. Top performers visible.
Pro tip: Pivot showing all rows = noise for big data. Top 10 by sum of revenue = focus on what matters. Discipline of filtering = readable analysis.
Like these prompts? There are full tutorials behind them.
Learn the workflows, not just the prompts. 300+ easy-to-follow tutorials inside AI Academy — and growing every week.
Pivot Charts + Reports
4 promptsPivot Chart
13/20✨ What it does
ChatGPT picks a pivot chart type (bar to compare, line for a trend), whether to chart the existing pivot, how formatting stays tied to it, and refresh behavior. Insert the chart from the live pivot, then refresh both before you paste into a deck.
Pivot chart from pivot. Output: chart type matching data (bar for compare, line for trend), chart from existing pivot vs new, formatting tied to pivot, refresh behavior. Charts = visual analysis.
Pro tip: Pivot chart = pivot visualized. Updates automatically when pivot updates. Bar/line/pie depending on question. Most users build separate charts; pivot charts faster + auto-updating.
Pivot-Based Dashboard
14/20✨ What it does
ChatGPT designs a dashboard from several pivots plus connecting slicers, a layout, and a refresh plan so the whole sheet stays in sync. Place one pivot per metric on your sheet, then connect the slicers so every chart moves together.
Dashboard from multiple pivots. Output: pivot per metric, slicers connecting, layout, refresh strategy, design. Multiple pivots + slicers = interactive dashboard.
Pro tip: Single pivot = analysis. Multiple pivots + connecting slicers = dashboard. Clicking slicer filters all pivots. Beats Power BI for: small data, occasional users, simple metrics.
Pivot Report Layout
15/20✨ What it does
ChatGPT configures compact, outline, or tabular layout, plus repeat item labels, blank rows, and which subtotals and grand totals to show. Switch to tabular if you will copy the pivot elsewhere, then turn repeat labels on.
Configure pivot report layout. Output: compact / outline / tabular (each different), repeat item labels, blank rows, totals on/off, grand totals. Layout matters.
Pro tip: Default compact layout = packed. Tabular layout = readable + exportable. Repeat item labels = pivot acts like flat table. Different layouts for different uses.
GETPIVOTDATA
16/20✨ What it does
ChatGPT writes a GETPIVOTDATA formula for [scenario], with syntax, when a regular cell reference is safer, and the tradeoffs of each. Paste the formula beside your pivot, then lock the field names so a refresh does not break the cell.
Use GETPIVOTDATA for [scenario]. Output: when useful (referencing pivot from elsewhere), formula syntax, alternative (regular cell reference), pros/cons.
Pro tip: GETPIVOTDATA references pivot cell by content (not position). Survives pivot restructure. Power-user for dashboards built on pivots; most disable by default.
Common Issues + Fixes
4 promptsPivot Field Not Showing Up
17/20✨ What it does
ChatGPT troubleshoots a missing pivot field: the source range left it out, the column is all blanks, the cache is stale, or the type is wrong. Expand your source and refresh, then add the field only after it appears in the field list.
Pivot field missing. Common causes: source range doesn't include field, field has all-blank values, pivot cache stale (refresh fixes), field type wrong. Output: troubleshooting steps.
Pro tip: Missing pivot field = check source range. Often new column added to source after pivot built; pivot doesn't auto-include. Refresh + check source range.
Date Grouping Issues
18/20✨ What it does
ChatGPT diagnoses date grouping that fails because dates are stored as text, formats are mixed, or blanks sit in the column, then gives the fix. Convert that column to real dates, then regroup after you refresh.
Pivot date grouping not working. Causes: dates stored as text (need conversion), mixed formats, blank cells. Output: diagnosis + fix. Date issues = #1 pivot problem.
Pro tip: Dates as text = pivot treats as text (no grouping). DATEVALUE / Text-to-Columns to convert. Verify with ISTEXT formula. Single bad row breaks grouping.
Pivot Performance
19/20✨ What it does
ChatGPT speeds up a slow pivot caused by huge data, volatile formulas in the source, or too many pivots on one range, including Power Pivot past 100K rows. Move your source to a Table or the data model, then refresh by hand instead of on every edit.
Slow pivot performance. Causes: huge data (>100K rows), volatile formulas in source, multiple pivots same source. Output: optimizations (Power Pivot for large data, single source, refresh manual).
Pro tip: Pivot on 1M rows = slow. Power Pivot (Excel data model) = millions of rows fast. Or: aggregate in source first; pivot on aggregated. Tool match matters.
Drill-Down Behavior
20/20✨ What it does
ChatGPT explains pivot drill-down: double-click a value cell to get a new sheet of the rows that made that total, for checking numbers or outliers. Double-click one surprising figure, then delete the extra sheet after you finish checking.
Pivot drill-down. Output: double-click a value cell → new sheet with rows that aggregated. Use cases (verifying numbers, exploring outliers). Drill-down = quick exploration.
Pro tip: Drill-down = double-click any pivot value. Excel creates sheet with underlying rows. Verify numbers, explore outliers, debug. Underused power feature.
Free tool
Prompt Optimizer
Turn a rough idea into a structured, professional AI prompt.
Frequently Asked Questions
Prompts are the starting line. Tutorials are the finish.
A growing library of 300+ hands-on tutorials on ChatGPT, Claude, Midjourney, and 50+ AI tools. New tutorials added every week.
7-day free trial. Cancel anytime.
Related guides