You can apply conditional formats to measure items. They provide the ability to visually represent and highlight data in the Viewer grid using indicators that are based on a predefined set of criteria. Conditional formats are applied by setting the Conditional Format property for a measure item to Yes and then using the Select Conditional Format window. For a detailed overview with instructions for setting up and applying conditional formats, see Working with Conditional Formats.
This view has a conditional format applied to highlight ranges of gross margin values. A green, yellow, or red indicator arrow will display depending on the measure item value. Additionally, values that fall into the red conditions are highlighted with a yellow background. The value is hidden but displayed in the measure item pop-up label.