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

You can pivot the grid on a worksheet 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 worksheet determines whether you can pivot the grid.

To pivot a grid:

  1. In a worksheet toolbar, click the Pivot icon.
    The Pivot data panel displays.
A worksheet called Account Targets. The Pivot icon is highlighted in red, and the Pivot data panel displays on the right of the screen.
  1. 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 close the Pivot data panel, click the pivot icon or the X in the top-right of the panel.