You can apply exception highlighting to individual
rows and columns of the crosstab, or to the entire crosstab.
Row and column highlighting
Row and column exception highlighting is used
to distinguish values that are inside or outside given ranges, in selected
columns or rows. For example, if you were analyzing sales figures and wanted to
know which regions had sales lower than a certain value, you could apply
exception highlighting to find those poorly performing regions.
Global highlighting
Global exception highlighting is used to
distinguish values that are inside or outside given ranges, across the entire
crosstab. For example, if you were analyzing sales figures across your entire
organization, and wanted to know which stores, regardless of location or size,
had sales higher than a certain value, you could apply global exception
highlighting to find those top-performing stores.
You can manually define up to seven ranges in
Voyager, by specifying end points for the ranges. When you enter a value in the
Exception Highlighting dialog box, that value defines the starting point for a
new range. The new range includes all values that are equal to or greater than
the value you entered, and less than the next starting point.
Alternatively, you can use one of the predefined
exception highlighting types (traffic light, shades of red, shades of green,
shades of red and green, hot and cold) to automatically define some of the
ranges for you.