Question: how to do percent change in excel pivot table?
Answer: Step 1: Start with a regular PivotTable, and add the field you want the percentage change calculation based on, to the values area twice:
Step 2: Right-click any values cell in the Sum of Sales2 column > select Show Values As > % Difference From…: