1. Anaplan User Experience
  2. Build apps and pages in the User Experience
  3. Build pages
  4. Worksheet pages
  5. Grids
  6. Edit the primary grid

You can edit the primary grid to display data either from a different saved view or a new custom view.

This enables you to expose users to the data that is of greatest relevance to their needs.

Your primary grid must display data from the same model as the rest of the page. However, if you change the view, you can display different data from within that model.

You can change the source model for the page from the Source model tab in Page settings.

If you have a Professional or Enterprise subscription, a workspace administrator can associate multiple models with the page. The page can still only display data from one model at a time. However, if you have access to multiple source models, you can use the Switch source model drop-down list to switch between them.

The option Users can edit list items is not available on personal pages.

Edit the grid

To edit the primary grid:

  1. Open the worksheet in designer mode.
  2. Select Configure view in the worksheet toolbar.

Configure the data source

To configure the data source for the primary grid view:

  1. In the Overview tab of the View configuration panel, select a View.
    The View dialog displays, with Custom views and Module views tabs displayed in the left panel.
  2. To select another view to use as the primary grid, choose:
    Custom views, then a view; or
    Module views, a module, then a view.
  3. If you selected a custom view, then you can configure that custom view. Use the toolbar icons at the top-right:
    • Pivot  to change the dimensions applied to RowsColumns, and Context selectors.
    • Filter  to change the values that display for line items in your grid, based on criteria you determine.
    • Sort  to arrange your data in ascending or descending order.
    • Show / Hide to choose which dimension items you want to display.
    • Totals Position to change where totals display on the grid.
    • Conditional Formatting to apply formatting to cells in your grid based on specified criteria.
    • Reorder to change the order of items on a grid.
  4. When you're happy with the preview, select Update. Alternatively, to discard changes, cancel the View dialog.

Configure the grid

Optionally, to configure list item and data editing, pivot, grid layout, and image settings:

The worksheet designer displays the View configuration panel to the right-hand side. It has three tabs: Overview, Grid, and Content. The Grid tab contains options to allow or disallow editing of cells and list items, and pivot, and options for grid size.
  1. Select the Grid tab.
  2. Under the Allow editing heading, toggle Users can edit list items right to enable users to maintain the list items. This does not grant additional permission to edit the data in cells.
  3. Toggle Users can enter and edit cell data right to enable users to edit data in grid cells.
  4. Toggle Allow pivot right to enable users to pivot the worksheet (this is enabled by default).
  5. Select a value from the Row height dropdown to change the height of rows on the worksheet.
    Standard, the default height, is one line high. Medium is two lines high, Large is four lines, and Extra large is eight lines.
  6. Toggle right under Rows or Columns to enable hierarchy filters.
  7. Select one or more line items under Line item image settings to display their values as images on the worksheet (these images display once you click Publish).
    The Line item image settings section only displays if your view contains valid link-formatted line items.
    You can display .jpg, .jpeg, .gif, or .png files as images on a grid card. Learn how to store image URLs.

Save changes

To save your changes, select Publish.
You can save the page as a draft if you're not yet ready to publish.

Disclaimer

We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.