Page 21 of 25PREVNEXT

PivotTable III: Show off your PivotTable skills

Using a Calculated Field formula to find the bonus amounts

The report with bonus amount calculated.

Now that you've figured out the bonus percentage, the next step is to figure out the bonus amount for each salesperson per quarter. This time you need a formula to multiply the quarterly Order $ totals by the quarterly Bonus %.

Again, use a calculated field by clicking PivotTable on the PivotTable toolbar, pointing to Formulas, and then clicking Calculated Field. In the Insert Calculated Field dialog box, enter this formula, which multiplies the order amounts by the bonus percentage:

='Order $'*'Bonus %'

Page 21 of 25PREVNEXT