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.
The correct answer is:
- Add a calculated field.
🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers