- 2 minutes to read
To enable interaction between the Grid and other dashboard items, you can use the interactivity features, as Master Filtering and Drill-Down.
You can use the Grid dashboard item as a filter for other dashboard items. To learn more about filtering concepts common to all dashboard items, see the Master Filtering topic.
The Grid dashboard item supports filtering by rows.
When Master Filtering is enabled, an end-user can click a grid row (or multiple rows) to make other dashboard items only display data related to the selected record(s).
A column, placed after the Measure column, do not participate in master filtering.
To enable Master Filtering, go to the Grid’s Interactivity menu and select the required Master Filtering mode.
To reset filtering, use the Clear Master Filter button (the icon) in the Grid’s caption.
You can use Master Filter or build criteria in the Filter Editor to filter total values. The Grid column’s drop-down filter menu does not affect grid totals as they are calculated on a server.
The built-in drill-down capability allows end-users to change the detail level of data displayed in dashboard items on the fly. The Grid dashboard item supports drill-down for rows. To learn more about drill-down concepts common to all dashboard items, see the Drill-Down topic.
When drill-down is enabled, an end-user can click a grid row to view the details.
Drill-down requires that the Columns section contains several dimensions at the top, from the least detailed to the most detailed dimension.
In OLAP mode, you can perform drill-down for either a hierarchy data item or several dimension attributes.
To enable Drill-Down, go to the Grid’s Interactivity menu and turn the Drill-Down option on.
To return to the previous detail level, click the Drill Up button (the icon) in the Grid’s caption.