Put Pivot Categories In The Order Readers Need

To set a Google Sheets pivot table custom order, drag the category headers directly in the pivot grid on a computer. For example, arrange stages as Planned → Active → Complete instead of alphabetically. After a successful move, the pivot table editor shows that field’s order as Custom. The same method works for categorical column headers. Google’s instructions document both operations.

Choose an order to compare the sample results; then apply that sequence in Sheets.

The feature is still rolling out as of October 1, 2026. Rapid Release rollout began September 22, with up to 15 days for visibility. Scheduled Release rollout starts October 5, also taking up to 15 days. Google lists availability for all Workspace customers and personal Google accounts, with no admin control for the feature. If dragging does not work yet, your account may not have received it. These dates and availability details come from Google’s rollout announcement.

Build A Pivot With Checkable Totals

This fictional dataset represents counts of public service requests by stage and district:

Stage	District	Requests
Planned	North	12
Planned	South	8
Active	North	5
Active	South	7
Complete	North	3
Complete	South	5

Paste it into cells A1:C7, including the headers. Then:

1. Select A1:C7 and choose Insert > Pivot table.
2. In the pivot table editor, add Stage under Rows.
3. Add Requests under Values, and set Summarize by to SUM.

If Sheets automatically inserts a suggested pivot, remove any fields you do not need before configuring this example. Google requires a header for each source column and documents this workflow in its pivot table creation guide.

The stage totals should be Planned 20, Active 12, and Complete 8, with a grand total of 40. If the grand total is hidden, enable Show totals for Stage under Rows, as described in Google’s customization guide.

These figures let you verify that reordering changes the presentation, not the result.

Drag Category Labels, Not Numeric Totals

1. In the pivot grid, locate the stage labels—not the numeric totals.
2. Drag Planned above Active, using the drop-zone indicator to place it.
3. Arrange the remaining labels so the sequence reads Planned, Active, Complete.
4. Open the pivot table’s Edit control and confirm that the Stage field’s order is Custom.

The completed summary should look like this:

Stage	SUM of Requests
Planned	20
Active	12
Complete	8
Grand Total	40

For a column layout, put Stage under Columns instead of Rows, then drag the stage column headers into the same sequence.

Google also supports selecting and dragging multiple category cells together. If the destination lacks space for the entire block, the cells revert to their original positions. Both operations are covered in the manual reordering instructions.

In this sample, workflow order happens to match request volume from highest to lowest. That does not make a value sort equivalent to a custom sequence: the intended stage order is Planned, Active, Complete regardless of the counts.

Keep Each Move Within Its Hierarchy

If you add District beneath Stage under Rows, Stage becomes the parent level and districts become children. Moving a parent carries its nested children with it.

You cannot move a category into a different hierarchy level or drop a categorical header into a value-header area. Google describes these boundaries in its feature announcement and manual reordering instructions.

Dragging labels in the grid changes category order. Dragging a field in the editor changes the pivot’s structure; it is not the same operation. Google’s pivot editing guide explains how fields are configured in the editor.

Check Totals And Filters Before Sharing

Google says custom arrangements persist across browser sessions, data refreshes, filtering and layout adjustments. It also says Excel imports and exports retain custom pivot sort orders, according to the feature announcement.

For the unchanged, unfiltered sample above, verify that each stage still has its expected total and that the grand total remains 40. A different row order should not change those figures.

After changing filters, recheck the visible categories. Google notes that filters configured by value need updating to include new source values; its customization guide covers that behavior. Also confirm that added records fall inside the pivot’s source range. An omitted record is a source or filter issue, not a custom-order issue.

Preserve The Sequence In A Public Data Table

For a public dataset, do not rely solely on the pivot’s visual arrangement. Prepare a flat summary with a numeric sequence field:

Stage order	Stage	Requests
1	Planned	20
2	Active	12
3	Complete	8

This gives you a publication-ready fallback while manual reordering rolls out. Use Stage order to establish the intended initial sequence, and keep the grand total separate from ordinary stage records so readers do not accidentally count it again.

Explain that Stage order represents workflow sequence, not a ranking by request volume. A table caption or summary can state the units, reporting period and category order.

Publish only reviewed, non-sensitive data. Before sharing the resulting page, check that its labels, values and initial row order match the reviewed summary.