Hi , I'm facing an issue with the Selector in the below image .
In Grid 1 , when I select Project Name = DARE , Product = Integration and Specifics = BU, I can see all other combinations as well which has these selected values whereas I just want to see the one highlighted below in Grid 2 .
Grid 1 has List drop down line items of a different module and Grid 2 has dimension as Unique Key. I have to apply Boolean filter to show all rows with selected Project /Product/Type & Species...any selection can be blank and grid 2 should show rows combination based on above selection only.
What formula would will be applied to eliminate the rest of the combinations !!?