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 .
What formula would will be applied to eliminate the rest of the combinations !!?
It you need to create a filter module or line item where you can query the value selected in the first grid with the property held within each line item.
To allow the user to display exactly what is selected you will need to create a logic in which a blank entry is always TRUE and will result in all items for that list showing in any filter.
Create a boolean line item in the second module for each of the lists in the first grid.
Call these line items - 'List Filter 1 - 4'.
For each line item use the following logic;
=ISNOTBLANK(FirstGrid.LineItem) OR SecondGrid.LineItem = FirstGrid.LineItem
This will return a TRUE outcome when the list item in the second grid matches the selection or the selection grid is left blank.
Add a final boolean line item. Call this 'Final Filter.'
=SecondGrid.LineItem 1 AND SecondGrid.LineItem 2....so that all line items in the second grid are covered.
Use this line item to inform a filter in the module.3
For each would have a boolean line item along the lines of:
isblank(grid1. line item) or grid1. line item=grid 2.line item
And then a line item that goes 1 and 2 and 3 and 4 - then filter on that one.
Hope that helps!3