This article describes how to go from a standard table...
...to a table that highlights top or bottom ranked values based on value, percentage and average:
1. Select your table.
2. Go to Properties > RULES on the object inspector.
3. To apply the rule, select the Plus (+) > Top/Bottom Rules.
4. Choose the desired definition: Top/Bottom 10 Items, Top/Bottom 10 % or Above/Below Average. Note, you can change the definition and value for the number of items or percentage once the dialog appears. When using the Average setting you can also specify the difference in standard deviations.
5. OPTIONAL: Update the Statistic (if different from the default).
6. Set the Color in the color picker.
7. Press OK.
8. OPTIONAL: To change the settings, right-click the rule under RULES in the object inspector > Edit.
Article is closed for comments.