1. Modeling
  2. Dimensions
  3. Page selectors

Model builders use dimensions to define a module's rows, columns, and pages. Use page selectors to navigate pages and filter the data in a module, giving further context to cell values.

You can display any dimension as a page selector, such as Versions and Time, lists, list subsets, line items, and line item subsets.

For example, the table below shows data from the Country Margin module. It has Products on rows, line items on columns, and Years and Regions on pages.

Years and Regions further contextualise the data in the module, only showing data that relates to a specific value in the page selector.

In this example, you can see data for all products sold in Europe in FY21. If you want to see data for other regions, choose a different value in the Regions page selector.

FY21Europe



RevenueCost of SalesMarginMargin %
Chocolates2,675,773744,8671,930,90672.16%
Sours3,132,459805,2692,327,19074.29%
Taffy3,436,924843,1542,593,77175.47%
Fudge1,957,370520,0751,437,29573.43%
All Products11,202,5262,913,3658,289,16173.99%

Create page selectors

When you create a module, put your dimensions on Pages in Pivot .

In modules and dashboards, page selectors appear above the grid in blue text. One page selector displays for each dimension. Select a page selector to change the value, or type in the Search field to find a value.

Note: If you do not want to use page selectors, you can nest dimensions on a maximum of three levels on columns or rows. 

Manage page selectors

If you want your page selector values to persist when you close and reopen a module, you can save the module as a filtered view

You can also publish page selectors to dashboards, and publish lists as page selectors

If you enable Synchronized Paging when configuring page selectors on a dashboard, page selector values persist between modules and dashboards for consistency. If you disable Synchronized Paging, modules and dashboards can show different page selectors at once.