Hi
I have a pivot table with store data , there are over 300 .
What would like to do is select multiple stores , I know i can do this by sellecting multple from the dropdown list ,
But as there are over 300 it takes ages to look down the list to find the ones i am interested in.
Is there a way of just typing in the store numbers to the filter criterea.
Hope this makes sense
I have a pivot table with store data , there are over 300 .
What would like to do is select multiple stores , I know i can do this by sellecting multple from the dropdown list ,
But as there are over 300 it takes ages to look down the list to find the ones i am interested in.
Is there a way of just typing in the store numbers to the filter criterea.
Hope this makes sense
