Multiple conditional analysis & formatting

 

Multiple conditional analysis & formatting is the tool suitable to format cells in a database based on a criterion previously specified
in the decision table.
Besides, this tool generates a most useful pivot table with mathematical operations in selected fields of the database.
For the following example, you will need a database and a 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.