For each record determine if it is for the selected plant.
Create an aggregating function to sum the number of records that are from the selected plant.
Use this function to filter at the product level not the record level.
Plant problem solution.twbx.zip 17.4 KB
Zach, I've been wondering how to do this, thanks!
Updated solution even simpler, eliminated need for separate [Sum of Selected] calculated field.
// For each record determine if it is for the selected plant
// Filter Product rows to only show those that have one or more Selected records.
Great, thank you Zach. I did manage to do this in the meantime but your solution is simpler.