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 instance: 3,667). style=red is a key/value pair; all possible keys and values are explained in the table below.
|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; this is useful in situations in which 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.||Any browser-renderable URL
Must be a fully-qualified URLURL must be enclosed in quotes
|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|