MicroStrategy ONE
How to Display Thresholds on a Report
Individual cell data can be automatically formatted differently than the data in the rest of the report, including a report displayed on a document. Data that is formatted differently calls attention to itself, and makes that data easier to locate for analysis.
To see a report displaying various types of thresholds, such as symbols, highlighted values, and so on, see the Formatting a Report chapter in the Basic Reporting Help.
Conditional formatting is formatting that is applied to values when certain conditions are met. For example, it is possible to have all profit margins below a certain percentage appear in red, while all other profit margins are displayed in black. The data that meets the condition is considered to be data that has passed the threshold of the condition; once data passes the threshold, the formatting is applied. So thresholds are cells of data that are formatted differently from the rest of the data on a report; the formatting is applied dynamically, whenever the report is re-executed.
Thresholds highlight particular data in a report by displaying special cell formats, symbols, images, or replacement text.
To Display the Thresholds on Your Report
- Run a report.
- From the Tools menu, select Report Options. On the General tab, select the Show thresholds checkbox.
- Click OK at the bottom of the dialog box.
To Display or Hide Thresholds on a Report in a Document
- Edit the document that contains the report.
- In Editable Mode, click the report to select it.
- On the Data toolbar, click the Toggle Thresholds icon
to switch between showing and hiding thresholds. - To display the Data toolbar, click Data on the menu bar.