How can a restrict filer to not apply in a particular column?
I have a table with 3 columns: project name, contractor, contractor quote fees.
Each project have more than one contractor quoting for the project, however, only one is selected.
I want a filter that can compare the fees for contractors. so If I select a contractor, I’ll like to see the fees quoted by other contractors for that project as well.
e.g. selecting contractor A should display all the projects for that contractor, and also show the quotes received by other contractor for that project