Paste your data, pick what to group by and what to total, and get the pivot table immediately. No spreadsheet, no signup.
Free, no signup. Edit it here, then take it with you as CSV.
| Region | Rep | Quarter | Amount | |
|---|---|---|---|---|
| Region | Q1 | Q2 | Total |
|---|---|---|---|
| North | 22,200 | 15,100 | 37,300 |
| South | 17,600 | 22,500 | 40,100 |
| West | 21,050 | 6,400 | 27,450 |
| Total | 60,850 | 44,000 | 104,850 |
Rows group down the side, columns across the top, and the value is what gets summarized in each cell. That is the whole model, and it is the part the click path in a tutorial tends to obscure.
A group-by with a second dimension. It takes many rows, buckets them by one field down the side and optionally another across the top, and applies one summary (sum, count, average) to a chosen value in each bucket. Everything else is presentation.
The value column is not numeric. Numbers stored as text, currency symbols, or a stray space will not sum, and a spreadsheet shows the result as blank or zero rather than telling you why. This tool warns you when most of the column failed to parse.
Only orientation, but it changes readability a lot. Put the field with more distinct values down the side, and the one with few (quarters, statuses, months) across the top. A pivot with forty columns is a table nobody reads.
Because a spreadsheet pivot is a snapshot over a fixed range: it needs a manual refresh, and it will not see rows added below the range. That single behaviour is the source of most stale numbers in reporting decks.
This is a snapshot. In Wisegrid the same thing stays current as the work changes, and the rollups read off it automatically. Start your 7-day free trial, no credit card required.