Multi Comparative grid

You can insert these columns by placing your cursor over a heading, clicking the drop-down arrow, and selecting the column to add.

You can click to expand a member into the 2nd By if one has been defined.

To show or hide a total row and/or average row, click on the Total/Average row in the grid. These rows show totals or averages for all members in the context—not just the current page.

In explore mode, you can highlight data based on custom criteria and/or percent of the total (i.e. heatmap). To access highlight settings, place your cursor over a column heading, click the drop-down arrow, and select Highlighting from the menu.

The standard grid shows measures in columns. You can switch to a different type (e.g., swapped columns/rows or scorecard) under grid settings.

In grid settings, you can choose how many members of each dimension to show at once. For the 1st By, this setting controls the maximum number of members on each page. For expanded data (e.g., 2nd By), members over this number will be truncated. Because an expanded grid includes multiple dimensions, the total number of rows may exceed the grid page size.