How to Apply a Conditional Style to a Column
Conditional styles on columns apply to Report Table Views and Report Matrix Views.
This enables to apply a conditional style on a column.
To apply a conditional style to a column:
1. Access the Report Table Column
(or Report Matrix Column
) properties.
2. Display its Style page.
3. Click Add
.
.4. Enter a Name to your conditional style.
5. In the Style Parameters list, select the style you want to add on condition.
6. Click Next.
7. In the Style Parameters list, select the style parameter and configure it in the right part.
Example: for a Cell Background Color or a Series Color, in Value keep "Fixed" and select a color.
8. Click OK.
9. In the Style page, select your style row.
10. In This style applies on the following condition:
• in the Name field enter a name describing the condition
• in the pane enter the code for your condition.
Example:
For a column with numerical values, to add a condition style on values greater than 80000 enter:
[1:ConditionGroup]
1=value,&Current,>,80000