Pivot cumulative revenue over time
Pivot tablesHardLLM judge scoringLatest run
Passed by 6 of 12 products on their best model. Failed: Autosheet in Sheets, Claude Code + Sheets MCP, Claude in Sheets, ChatGPT + Autosheet MCP, ChatGPT + Drive MCP and ChatGPT in Sheets.
Prompt
In a new
Pivotsheet atA3, create a pivot table showing cumulative revenue over time.
Data
Starting sheet| A | B | |
|---|---|---|
| 1 | Date | Revenue |
| 2 | 2025-01-17 | 4200 |
| 3 | 2025-01-03 | 2500 |
| 4 | 2025-01-25 | 6100 |
| 5 | 2025-01-08 | 3100 |
| 6 | 2025-01-12 | 4700 |
| 7 | 2025-01-21 | 5200 |
Pivot
Starting sheet| A | |
|---|---|
| 1 |
Expected result
Pass criteria
All must be met, checked by an LLM judge.- A real pivot table on Pivot!A3
- Dates in ascending order
- A correct running total, a field of the pivot itself
Passed 13
Autosheet in Excel Opus 5.5 · Medium
Autosheet in Excel GPT-6 Astra · Low
Autosheet in Excel Sonnet 5.5 · Medium
Claude in Excel Opus 5.5 · High
Autosheet in Excel Haiku 5.5 · High
Autosheet in Excel GPT-6.1 Sol · Medium
Claude Code + Autosheet MCP Opus 5.5 · Medium
ChatGPT in Excel GPT-6 Astra · Medium
Claude in Excel Haiku 5.5 · High
Claude in Sheets Haiku 5.5 · High
Autosheet in Excel GPT-6 Luna · High
Copilot in Excel Auto
Gemini in Sheets Auto
Failed 9
Autosheet in Sheets Opus 5.5 · Medium
Why it failed: The pivot table itself only shows non-cumulative Sum of Revenue (2500, 3100, 4700, etc.), not the running total over time.
Claude in Sheets Opus 5.5 · Medium
Why it failed: The pivot table itself only displays regular sum of revenue ($2,500, $3,100, etc.), not cumulative revenue.
Claude Code + Sheets MCP Opus 5.5 · Medium
Why it failed: The pivot table itself does not show running total revenue; its value field only shows discrete revenue amounts (2500, 3100, etc.).
ChatGPT + Autosheet MCP GPT-6 · Medium
Why it failed: The pivot table itself does not show running total revenue; it only shows regular daily revenue in column B.
Autosheet in Sheets Haiku 5.5 · High
Why it failed: The pivot table itself only displays regular sum of revenue per date, not the running total.
ChatGPT + Drive MCP GPT-6 · Medium
Why it failed: The pivot table itself does not show running total; it only shows regular Sum of Revenue.
ChatGPT in Excel GPT-6 Luna · High
Why it failed: The pivot table itself does not show cumulative revenue; the pivot contains only standard 'Sum of Revenue' values in column B.
ChatGPT in Sheets GPT-6 Astra · Medium
Why it failed: A real pivot table was not created; a formula-based summary table was built instead.
ChatGPT in Sheets GPT-6 Luna · High
Why it failed: No pivot table: the summary is built with formulas instead.