Conditional formatting expressions

Valid MDX format strings contain properties that apply special rendering for the HTML pivot tables. A format string follows this syntax:

| # , # # # | style = red

The leading Pipe ( | ) tells Analyzer that this format string contains properties. The '#,###' is the measure's value format, which in this example is one number separated from three further places or decimal places by a comma, for example, '3,667'. The 'style=red' string is a key/value pair; all possible keys and values are explained in the table below.

The following properties are supported by Analyzer:

Indicator Type	Description	Values
style	Changes the cell background color.	red yellow green
arrow	Shows a trend arrow that points up or down. A value of 'none' will not render the arrow, which is useful when you only want to show one directional arrow instead of two.	up down none
link	Creates an HTML link which will open in a new window when clicked in Analyzer.	Can be any browser-renderable URL. It must be a fully-qualified URL. The URL must be enclosed in quotation marks.
image	Renders a custom image that you specify. This image file must be stored in the /pentaho-solutions/system/analyzer/resource/image/report/ directory.	An image file name, with extension.