1. Anaplan User Experience
  2. Build apps and pages in the User Experience
  3. Display data
  4. Pivot

Pivot enables you to move your dimensions (for example, lists, line items, time, or versions) between rows and columns, or display them as page selectors.

There are two types of view: module views and custom views. Module views are created in the source module; their dimensions are fixed and cannot be pivoted. Custom views are created in the primary grid, enabling you to customize the grid. Only custom views can be pivoted. 

To pivot the view of the data:

  1. In designer mode, click Select view.
    The Select primary grid dialog displays.
  2. Select Custom views.
    A list of the modules in your model displays.
  3. Select the module that contains the grid you want to pivot.
  4. Select the pivot icon from the toolbar at the top right of the preview.
    The Pivot data panel displays.
The Select primary grid dialog. In the worksheet toolbar, the pivot icon is highlighted with a red box. The Pivot data panel displays, implying the icon has been clicked.
  1. In the Pivot data panel, drag dimensions to the required Context selector, Column or Row, and drop the dimension when a solid horizontal line displays at the position you want.
In the Pivot data panel on the right of the screen, the Versions dimension has been clicked and dragged to beneath the Time dimension in the Columns box. As such, a horizontal line displays, which indicates it will be moved to Columns when unclicked.
  1. Optionally, swap two dimensions. Drag one dimension over the top of another and drop it when the outline of the dimension changes color.
In the Pivot data panel on the right of the screen, the Versions dimension has been clicked and dragged to over the Time dimension in the Columns box. As such, the Time dimension is surrounded by a line, which indicates the two dimensions will be swapped when unclicked.
  1. To close the Pivot data panel, click the pivot icon or the X in the top-right of the panel.