Here
is some information about applying conditional highlighting to tables
and graphs:
Conditional
highlighting is measure-based, so the table or graph must include
at least one measure that can be used in the condition.
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.
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.