1. Anaplan User Experience
  2. Use apps and pages in the User Experience
  3. Worksheets
  4. Grid overview
  5. Pivot the grid

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. 

To pivot a grid:

  1. In a worksheet toolbar, click .
    The Pivot data panel displays.
  2. Drag dimensions to the Context selector, Column or Row sections, and drop the dimension when a horizontal line displays at the required position.
    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.
The Pivot data panel is open, and the Line items dimension is clicked and dragged from the Columns section to the Rows section. As such, a horizontal line displays in the Rows section.
  1. Optionally, swap two dimensions. Drag one dimension over the top of another and drop it when the outline of the dimension changes color.
The Pivot data panel is open. The Line items dimension is clicked and dragged from the Context selectors section to over the Accounts dimension in Rows. As such, the outline of the Accounts dimension has changed color, which means the dimensions will be swapped.
  1. To reset your pivot settings to the default for the page, click the Reset pivot button at the bottom of the Pivot data panel.

To close the Pivot data panel, click , or  in the top-right of the panel.

Your pivot configuration is remembered by your browser, until you reset the pivot, or your page builder modifies the underlying view. To preserve your pivot, you can select Save personal copy from the Page options toolbar menu of the page, and then apply a pivot to your personal copy in design mode.