SumAverageMinMaxCountCount unique
Aggregations
Sum, average, more.
Six operators ship. Switch by tap. The pivot, the totals, and the grand total all rerun together.
Pivot Tables
Pivot a source. Reshape the story.
Drop a field. The grid regroups.
Rows
Region+ field
Columns
Quarter+ field
Values
sum(Revenue)+ field
Drop fields here. The pivot recomputes the moment you let go.
Pivot · sum(Revenue)
$ thousands| Region | Q1 | Q2 | Q3 | Q4 | Total |
|---|---|---|---|---|---|
| North | 12.4 | 14.8 | 16.2 | 18.9 | 62.3 |
| South | 9.1 | 11.2 | 13.4 | 15.8 | 49.5 |
| East | 18.4 | 21.3 | 23.9 | 27.4 | 91.0 |
| West | 7.8 | 9.4 | 11.1 | 13.2 | 41.5 |
| Total | 47.7 | 56.7 | 64.6 | 75.3 | 244.3 |
The fields
Five chips, any axis.
A pivot starts with a question. Drop a field on the row, the column, or the value. Watch the table form.
RegionQuarterPlanRevenueChurn
drag any of these
Drag and drop
No menus, no setup.
The chip carries the column. Drop it on the row well, the column well, or the value well. Switch axes with a flick.
- Multiple rows or multiple columns. Two axes nest cleanly with subtotals on each.
- Computed columns work the same way as raw columns. Pivot a derived metric without a second source.
- Search and sort on the underlying source narrow the pivot. The pivot redraws on every change.
The roll up
Six ways, to count it.
Pick the math. The totals row chooses the right roll up to match.
| Q1 | Q2 | |
| North | 12 | 15 |
| East | 18 | 21 |
Preview
A small grid.
A two by two pivot reads in a beat. The same logic scales to ten by twenty without losing the rhythm.
·
Q1
Q2
North
12
15
East
18
21
Σ
30
36
Totals
Always present.
Row totals across, column totals down, grand total in the corner. Tinted accent so the eye lands on them last.
At a glance
The reader sees, the answer first.
6
aggregations ready
2
axes, nest cleanly
0s
wait, on a regroup
A pivot is a question. The pivot view holds the answer. Switch back to the grid the moment you want to write into a cell.
In short
Questions, answered.
Can I pivot any source?+
Yes. Anything in the workspace data library can be pivoted. Computed columns work too.
Which roll ups ship?+
Sum, average, min, max, count, and count unique. Each one updates the totals row instantly.
Can I bind a chart to a pivot?+
On the way. Today the pivot is a read view. Switch back to grid for edits.
Does sort and search apply?+
Yes. The pivot honors the source filter and the active sort. Pivot a slice without leaving the page.