FingerprintUser
New Member
- Joined
- Aug 23, 2020
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
I have a workbook with multiple pivot tables. I've taken the interesting information from those pivot tables and used GETPIVOTDATA to summarize the information on one sheet. I added in a slicer that is connected to these tables, so users can filter the data on the main page by which section the data is coming from. All of this works great. However, since GETPIVOTDATA only works with data that is visible on the pivot table, I am running into the problem of some fields being collapsed when there is no data for the filtered section. This means when the user removes any filters from the data, my main page is missing information from the fields that were collapsed in the pivot table. My users will not have any idea how to expand a field, and I don't actually want them messing with the pivot tables.
Is there a way to either stop a field from collapsing, even when there is no data for that field? Or, is there a way to have the field automatically expand when a user removes the filters with the slicer?
Is there a way to either stop a field from collapsing, even when there is no data for that field? Or, is there a way to have the field automatically expand when a user removes the filters with the slicer?