Excel Filter Not Filtering Correctly

Hi,

I am trying to collect some data for a project off of my table in excel. When I go filter a certain cateogory, it doesn't work. Example, filtering vendors and I would like to see how much each vendor is producing. When I go to filter, it'll filter that vendor, but it will still show all the vendors on the page. It will also not bring up all that vendor has made and will scatter it across the table. Example below:

What can I do to fix this?