I currently have a rule that sorts the rows in my table in a particular order. However, some rows should be hidden and others not, which changes frequently (wave on wave) and at the moment, I have to manually update my rule every wave.

I would like to be able to have a lookup table or other data source that my rule can look at to determine what the order should be and which rows should be hidden, etc.