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. In the following sample, all the regions are selected, and the total is displayed.
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 (in this instance, all the regions).
For more examples, see the MicroStrategy Report Services Document Creation Guide.
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.
Related topics