MicroStrategy ONE
Derived metrics, summary metrics, and attributes in conditional formatting
Conditional formatting can use derived metrics and summary metrics in the condition definition. For example, a document contains cost, profit, and revenue by region and employee, and is grouped by region. A summary metric for the average profit is displayed in the Region Header. For regions with an average less than $100,000, the region name appears in a box.
You do not have to use a metric as the condition; you can also use attributes. For example, you want to quickly identify employees who work in the North (that is, either the Northeast or Northwest region). Therefore, the condition definition is Region In list {Northeast, Northwest}. The conditional format highlights Northeast and Northwest employees, but not Mid-Atlantic employees.