You can pivot the grid on a worksheet or a grid card on a board to rearrange your data and identify insights.
If you pivot a grid, it removes all grid customizations except conditional formatting.
The page builder who designs a page determines whether you can pivot the grid.
Pivot a grid card
To pivot a grid card:
- Hover over your grid card and select Pivot .
- On the Pivot data panel, drag and drop dimensions to the required Context selector, Column, or Row.
You can also swap two dimensions. Drag one dimension over another and drop it when the dimension outline changes color.
If the Column or Row section contains multiple dimensions, they are nested on the worksheet. Dimensions at the top of a section occupy the outermost position on a grid, and those at the bottom of a section occupy the innermost position on a grid. - Select Update.
Changes to your pivot configuration display on the grid card. - Select Close to close the Pivot data panel.
Your pivot configuration is remembered by your browser, until you reset the pivot, or your page builder modifies the underlying view.
Use the pivot panel on a combined grid
Use the pivot panel to set context selectors, or reconfigure your combined grid.
To use the pivot panel:
- Select or hover over a grid to reveal its toolbar, and select Edit .
The Card configuration panel displays. - In the Overview tab, select View designer.
- In View designer, select Pivot above the grid.
The Pivot data panel displays. - You can see separate column fields for each grid section, and each dimension option for each grid section is labeled with a different color.
- You can:
- Drag and drop dimension options into the Context selectors field to set them as your context selector.
If you put more than one identical dimension from different grid sections into the Context selector field, they'll be combined into one context selector. For example, if two grids in your combined grid contain the time dimension, and both are put into the Context selectors field, only a single Time context selector will display. - Rearrange the layout of your grid by reordering the dimension options within the column field for its section.
- Drag and drop dimension options into the Context selectors field to set them as your context selector.
Note: Row dimension options can't be used as context selectors or moved into columns.
Reset the pivot for a grid card
To reset a card, select Pivot , then select Reset pivot on the Pivot data panel.
To reset all cards on your page to the default options set by the page builder, select Page options > Reset page. On the Reset this page? dialog, select Reset.
