Using data from the report in a formula entered outside the report area.
Finally, you'll figure out the total bonus amount for each salesperson by using a formula that's outside the report. That means you won't use a calculated field, which is only used inside a report. This is by way of letting you know that you don't have to stay inside the report to use its data in formulas elsewhere.
- Click in a cell outside the report.
- Type =SUM(.
- Highlight the numbers you want to add.
- Press ENTER.
Peacock has something to crow about. Her bonus is $23,083. And you've made it! So take a bow. Everyone should be more than impressed with your PivotTable skills.
Note When you work on your own, you'll probably be surprised by the GETPIVOTDATA function, which can kind of pop up in front of you when you create a formula outside of a report. The function is a more advanced feature, which we'll show you in the practice session.