Is there a way to set up a filter that allows me to sort by header but then
show all the data? For example:

Sale's Name Product
Rob gum
Kim gum
Rob brush
Rob gum
Kim turtle

Can I set it up to filter for each header Sales/Product. So, I can email
this to a group and if they want to click on the product header, they can
select from the drop down, gum, and also see that brush and turtle were
products sold by Rob and Kim? And, also, the other way, I can click on Name
and sort filter/sort by Rob but also see all items by Kim?? Hope this makes
sense.