Question: You want to add a column to the PivotTable below that shows a 5% bonus for each sales rep. That data does not exists in the original data table. How can you do this without adding more data to the table?
- Add a new PivotTable field.
- Add a calculated item
- Add a new Summarize Value By field.
- Add a calculated field.
Answer: The correct answer of the above question is Option D:Add a calculated field.