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?

  1. Add a new PivotTable field.
  2. Add a calculated item
  3. Add a new Summarize Value By field.
  4. Add a calculated field.

Answer: The correct answer of the above question is Option D:Add a calculated field.