Excel pivot tables vs asking a question: a side-by-side test

The test setup

One Excel file of sales orders: one row per order, with order date, region, product category, sales rep, order value and a returned flag. Five questions a sales or finance lead would actually ask:

1. What was revenue by month this year?
2. Which region grew fastest from Q2 to Q3?
3. Who are the top 5 reps by revenue this quarter?
4. What share of orders were returned, by category?
5. Why did revenue drop in August?

Each one is answered twice: once with a pivot table, once by asking the question in DashboardGPT.

Question 1: Revenue by month

Pivot table: Insert a pivot table, drag order date to Rows, group it by months and years, drag order value to Values, check it is set to Sum, then insert a line chart.

Asking: "What was revenue by month this year?"

Verdict: both are quick. The pivot takes a few more clicks and the date grouping step trips people up, but an experienced Excel user gets there fast.

Question 2: Which region grew fastest from Q2 to Q3?

Pivot table: Put region in Rows and quarter in Columns, filter to Q2 and Q3, then add a calculated column outside the pivot for the percentage change and sort by it. The formula breaks if the pivot changes shape.

Asking: "Which region grew fastest from Q2 to Q3, as a percentage?"

Verdict: asking wins clearly. Pivot tables do not calculate period-over-period growth without extra work.

Question 3: Top 5 reps this quarter

Pivot table: Rep in Rows, order value in Values, filter the date to this quarter, then use a Top 10 value filter set to 5.

Asking: "Top 5 sales reps by revenue this quarter."

Verdict: close. The pivot's Top 10 filter works, but it is buried in a menu many users never find.

Question 4: Return rate by category

Pivot table: Category in Rows, count of orders in Values, then a second value field for returned orders, which needs the returned flag to be numeric, then a calculated field or an outside formula for the rate.

Asking: "What share of orders were returned, by category?"

Verdict: asking wins. Rates and ratios are awkward in pivot tables.

Question 5: Why did revenue drop in August?

Pivot table: There is no single pivot for "why". You build several: August vs July by region, then by category, then by rep, each time rearranging fields and comparing.

Asking: Start with "Why did revenue drop in August compared with July?", then follow up on the chart: "Break this down by region", then "Only the West region, by category".

Verdict: asking wins by the widest margin. Each follow-up builds on the last, and all the charts stay side by side on the canvas.

Scorecard

Where pivot tables still win

• A report layout you reuse every month inside a workbook your team already relies on.
• Exact formatting for a finance pack or a board appendix.
• Offline work or files that cannot leave your machine.
• Very small, familiar datasets where you already know the answer's shape.

Where asking wins

• Growth, shares and rates that need extra formulas in a pivot.
• Follow-up questions that would mean rebuilding the pivot each time.
• Explaining a change rather than only showing it.
• People who do not use pivot tables but know exactly what they want to ask.

How to try it with your own Excel file

1. Save the sheet you usually pivot as a clean table: one header row, one row per record, no subtotals.
2. Upload it on the free Explore plan (Excel and CSV files up to 50 MB).
3. Ask the question you would normally answer with a pivot.
4. Compare one number with your pivot to confirm the file was read correctly.
5. Ask one "why" question and follow it up twice.