Working with Conditional Highlighting

Here is some information about applying conditional highlighting to tables and graphs:
Requirements
For graphs, conditional highlighting is measure-based. The graph must include at least one measure that can be used in the condition. For tables, conditional highlighting is based on measures or categories. The table must include at least one measure or category that can be used in the condition.
Using category values for conditional highlighting
Highlighting on category values is always case sensitive. You might need to create more than one conditional highlighting rule to account for all the variations of a value.
How conditions are evaluated
Highlighting conditions are evaluated based on raw values. The use of raw values affects how conditions are applied to rounded values. For example, in your table or graph, you have formatted product prices so that they are rounded up or down. The actual cost of a pair of Eclipse running shoes is $49.65. In the table or graph, the $49.65 price is rounded up to $50. If you specify that you want to highlight all products that cost less than $50, the Eclipse running shoes are highlighted because their actual price is less than $50.
Creating conditions for percentages
If you are creating a condition for percentages, you must enter the conditional value as a decimal number. For example, if you want to filter for values above 50%, enter .5 as the conditional value.
Creating rules
In general, there are two types of rules that you can create:
  • Rules that compare a measure to a fixed value. For example, you might create a rule for Sales > 1000.
  • Rules that compare one measure value relative to another measure value. For example, you might create a rule for Sales > Budget.
SAS Web Report Studio processes these rules in the following ways:
  • For the first type of rule, the condition is applied at the current level of the data source. For example, if you drill down into the data and then specify conditional highlighting, the condition applies to the level that is currently displayed.
  • For the second type of rule, the condition is applied at all levels of the data source, regardless of the current level.