this is going to be a bit hard to explain, lets see if i succeed 
OK so I'm working with about 100K lines of data. In the artist column not all of these entries are unique. Lets say each artist is mention 10-100 times. This means when I goto the filters so I can choose only one artist the list is still pretty long. I'd like to be able to type in, say, Pitbull, and tick that checkbox, and have only his rows show up. However when I do that for some reason all the other checkboxes stay ticked. My unchecking them before typing this name doesnt change that. If I click 'add to selection' that doesnt change anything either.
help!

OK so I'm working with about 100K lines of data. In the artist column not all of these entries are unique. Lets say each artist is mention 10-100 times. This means when I goto the filters so I can choose only one artist the list is still pretty long. I'd like to be able to type in, say, Pitbull, and tick that checkbox, and have only his rows show up. However when I do that for some reason all the other checkboxes stay ticked. My unchecking them before typing this name doesnt change that. If I click 'add to selection' that doesnt change anything either.
help!