Forum Discussion
Calculate change using pivot table
Hello! Wondering if someone can help me achieve the following: I need to quickly be able to find changes between two data sets on a weekly basis. I am currently comparing data from last week to this ...
Click in the pivot table.
In the PivotTable Fields task pane, click on the value field, and select 'Value Field Settings...' from the drop down menu.
Activate the 'Show Values As' tab.
Select 'Difference From' from the drop down.
Select the column labels field in the 'Base field' list.
Then select (previous) in the 'Base item' list.
Click OK.