Hello everyone. I want to be able to pull data from my pivot table and show it on a different sheet as a summary page. I tried to use =GETPIVOTDATA but I also want specific data by selecting only one field from one of the filters. So I guess is there a way to lock the values I want so that the summary page does not change if I select different fields in the filter other than copying the cell and pasting the values only?
Thanks.
Bookmarks