Forum Discussion
AmyYang
Sep 06, 2023Brass Contributor
How create pivot table or table that shows the change after refresh
Hello, Currently, I have created a pivot table that tracks that number of completed activities, so when I click refresh, the pivot table will update. However, the problem is that I would like...
tanayprasad
Sep 06, 2023Brass Contributor
Hi,
By adding a calculated field to a pivot table, you can determine how much the value has changed from the previous one. Here's how you can do it-
- Go to the PivotTable Field List.
- Right-click the field that represents the total number of completed activities in the "Values" area and select "Value Field Settings."
- In the "Value Field Settings" dialog box, select "Show Values As" and "% Difference From."
- In the "Base Field" dropdown, select the field that you want to compare to (in your case, the "Month" field).
- In the "Base Item" dropdown, select "Previous."
- Click "OK" to create the calculated field.
- Right-click on the calculated field in the Values area of the PivotTable.
- Select "Value Field Settings" again.
- In the "Value Field Settings" dialog box, select "Number Format."
- Choose the number format that you prefer (e.g., "Number" with zero decimal places).
- Click "OK" to apply the number format.
This should do it.