Filtering though drop down lists
I have been trying to search for how to use drop downs to filter a list. I have a report that organized Product Name, Product ID, Location and Status. This list has a subsummary to separate things into Product name.
I would like to have pull downs at the top that would allow filtering. For instance, I'd like to select location and it only show the items from that location. I could further filter or remove that filter and filter other fields.
Is this done by custom find scripts and script triggers or is there an easier way to do it?
Thanks for the help.