Showing Totals in Selectors

Selectors provide interactivity to dashboards, allowing each user to change how he sees the data. A selector can change panels, the focus of a Grid/Graph, or dynamic text fields (a text field that is a reference to an object on a report) in a panel stack. For more information on selectors in general, see Providing interactivity to users: Selectors.

Selectors that contain attribute, custom group, or consolidation elements as selector items can also include an option to display totals. The total is calculated for all the selector items. A user can choose whether to display specific elements, all of the elements at the same time, or the totals.

For example, a document contains a Grid/Graph with Region and several metrics. A selector (the check boxes on the left) targets the Grid/Graph and displays all the regions (the selector source), as well as the Total option, as selector items.

Note: The All option does not have to be selected for the total to be displayed. However, the total is always calculated using all the selector items.

To show totals in a selector

Open the document in Design or Editable Mode.
Right-click the selector and select Properties. The Properties dialog box opens.
Click the Selector tab, then select the Show option for Total check box.
Notes:
- If the Action type is defined as Select metric or Select panel, the Show option for Total check box is not available.
- If Apply selections as a filter is selected, the Show option for Total check box is not available. For a comparison of filtering and slicing selectors, see Applying selections as filters or slices.

Click OK.