I have a SharePoint Library with 100k+ records with the following fields:
Market (about 10 different choices);
Market Unit (about 10 Market Units per each Market);
In order for a user to find a project they first need to filter by Market, then by Market Unit, etc. and this is a painful exercise for such a large list.
Is it possible instead to create a SharePoint Page where I can add 10 buttons for Markets, then dynamically add buttons for Market Units and connect these buttons to the SharePoint list to get it filtered when a button is pressed? Did anyone come across any similar solution?
Any other work around is welcome for this issue.