The filters seem to be working fine.
You do not need to have the RMO field in the summary table if you only want to select the Status and LGB from the summary table.
If you want to give option to filter the details sheet based on the RMO, you can just give the RMO filter to be shown at the top for users to select.
As of now, if you click on any box on summary table, the other sheets are being filtered out based on the status/lgb selected.
Is it not what you are expecting ?
Hi there J
I need RMO field to be the factor for filtering here because it is the lowest level.
Currently, it is filtering based on Status and LGB from the summary table which will bring up lines of data that I do not want to see...
For example in the summary table, if i click on a box that has 5 RMO ids - The filter will filter based on Status and LGB dimensions which will result in more data being filtered which is not accurate for users. How should i fix this? Appreciate your advice!