Drag columns into Rows to group (nest as many as you like), drop columns into Values to summarise (sum, count, average, min, max), and add a filter to limit which rows count. The result is a live table over the source sheet, not a frozen Excel-style snapshot.
The summary is computed on the server over the WHOLE sheet, so the totals are honest even on very large sheets. The header tells you exactly how many rows were scanned. A columns-axis crosstab and pivot charts are the next step.
Activity
- Ryan K. opened this entryJun 1, 2026
- moved from Under review to In progressJun 1, 2026
- ShippedJun 5, 2026
Team notes 2
Notes here are local-only for now. To reach us, start free and send feedback from inside the app.
Group-by is much simpler than a full pivot, and a live view on the source sheet beats an Excel-style disconnected snapshot. Both are under review; neither is committed.
Shipped. Rows + Values + Filter, with the aggregate computed server-side over the whole sheet so the totals are exact. The header reports the true scanned-row count, never a windowed estimate. Rows-grouped first; a columns-axis crosstab is next.