If the premade conditional formatting options in Analyzer are not precise enough for your needs, you can apply custom formatting to a measure by using an MDX expression, as explained below.
- Right-click a measure in the grid, then select Column Name and Format... from the context menu. The Edit Column dialogue will appear.
- Select Expression from the Format drop-down list. A default MDX expression that prints green or red arrows in cells if their values are greater than or less than zero, respectively, will appear in the MDX Format Expression field:
Case When [Measures].CurrentMember > 0 Then '|#,##0|arrow=up' When [Measures].CurrentMember < 0 Then '|#,##0|arrow=down' Else '|#,##0' End
- Modify the expression to suit your needs. Consult Conditional Formatting Expressions for more information on conditional formatting syntax and options. Note: If the MDX expression is invalid, an invalid report definition error will appear at the top of the dialogue.
- Click OK to commit the change.
The analyzer report will refresh and apply the formatting choices you specified.