You have a PivotTable with rows for each Sales Rep and columns for each year's sales: 2014, 2015, and 2016. To add columns in between the years that show the difference in sales, f... You have a PivotTable with rows for each Sales Rep and columns for each year's sales: 2014, 2015, and 2016. To add columns in between the years that show the difference in sales, first add the Sales field to the Values box twice. Then what?
Understand the Problem
The question is asking how to manipulate a PivotTable in Excel to display the difference in sales between two years after adding the Sales field to the Values box twice. It requires understanding of PivotTable functionalities and options.
Answer
Right-click the second Sum of Sales column, and click Show Values As > Difference From
Right-click the second Sum of Sales column, and click Show Values As > Difference From
Answer for screen readers
Right-click the second Sum of Sales column, and click Show Values As > Difference From
More Information
This operation calculates the difference between each pair of yearly columns, allowing for easy comparison of sales data.
Tips
Ensure you are selecting the correct 'Show Values As' option to avoid incorrect calculations.