Hello,
I'm using multiple filters and slicers in my pivottable with more than 200 rows.
Ok, so I have filtered in my slicers.
Is it possible to see only the filtered lines in my pivottable filters, so I can select individual rows based on my previously made filter?
So as an example:
I have a slicer "year" and "location".
Now I select 2018 and location1 in the slicers. In my pivottable I now want to select a number of rows based on my own knowledge, by checking the boxes of the ones I find interesting. Is there a way that in this filter I can see only the let's say 20 rows that are in location1 in year 2018? Or do I still have to scroll through the 200 rows that are in total in my pivottable.
(I'm OK with VBA codes if that's necesary).
Hope I clearified the question enough,
Thanks in advance,
I'm using multiple filters and slicers in my pivottable with more than 200 rows.
Ok, so I have filtered in my slicers.
Is it possible to see only the filtered lines in my pivottable filters, so I can select individual rows based on my previously made filter?
So as an example:
I have a slicer "year" and "location".
Now I select 2018 and location1 in the slicers. In my pivottable I now want to select a number of rows based on my own knowledge, by checking the boxes of the ones I find interesting. Is there a way that in this filter I can see only the let's say 20 rows that are in location1 in year 2018? Or do I still have to scroll through the 200 rows that are in total in my pivottable.
(I'm OK with VBA codes if that's necesary).
Hope I clearified the question enough,
Thanks in advance,
