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.
FY21 | Europe | |||
Revenue | Cost of Sales | Margin | Margin % | |
Chocolates | 2,675,773 | 744,867 | 1,930,906 | 72.16% |
Sours | 3,132,459 | 805,269 | 2,327,190 | 74.29% |
Taffy | 3,436,924 | 843,154 | 2,593,771 | 75.47% |
Fudge | 1,957,370 | 520,075 | 1,437,295 | 73.43% |
All Products | 11,202,526 | 2,913,365 | 8,289,161 | 73.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.