Derived metrics, summary metrics, and attributes in conditional formatting

Conditional formatting can use derived metrics and summary metrics in the condition definition. For example, the following 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 profit less than $100,000, the region name appears in a box.

You can also use attributes as the condition. For example, you want to identify employees who work in the North (that is, either the Northeast or Northwest region). The condition definition is Region In list {Northeast, Northwest}.

In the following sample, the Northeast employees are highlighted, but not the Mid-Atlantic employees. If any Northwest employees were displayed in the sample, their names would be highlighted as well.