| |||
Multiple conditional analysis & formatting is the tool suitable to
format cells in a database based on a criterion previously specified in
the decision table. | |||
Once you have entered the information in the dialog, as shown above, click on the Do It button. The result is shown below: | |||
If in addition you wish to have a report in a pivot table with
mathematical operations in each field of the database, just check the Add
category checkbox in the dialog to enable this option. Then click on the Add pivot table report button, and choose the fields and math operations you want to perform. |
|||