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...
SergeiBaklan
Sep 06, 2023Diamond Contributor
Afraid that's not possible. If activities are linked to date, when you may calculate total activities compare to total in previous period, whatever.
However, perhaps with cached PivotTable something could be done with VBA programming, not sure.