I currently have data that looks like this (screenshot 1) and have the linked pivot table beside the source data and need to constantly filter on the source data and see the changed data in the pivot table.
How do I:
1. Lock the pivot table right where it is so that when i filter on the source data on the left, the pivot table does not 'disappear' (see 2nd screenshot)
2. Ensure that data in the pivot table only shows based on the filtered source data?
Ive tried freezing panes on cell E5 but thats not helping. Whenever I filter on the source data, the pivot just get hidden because of the rows being filtered.
How do I:
1. Lock the pivot table right where it is so that when i filter on the source data on the left, the pivot table does not 'disappear' (see 2nd screenshot)
2. Ensure that data in the pivot table only shows based on the filtered source data?
Ive tried freezing panes on cell E5 but thats not helping. Whenever I filter on the source data, the pivot just get hidden because of the rows being filtered.