Report formula - multi-select text field

I am trying to add a report formula to get all records based on 2 different fields within the same table.  The first field type of a text lookup field, it displays a list of operating facilities.  Once I have the correct operating facility, I then want to get a list of records from  a multi-select field, both are in the same table.

For example:
Get all records for X operating facility 
Then list all records where status =
Secured
Pending
Onboarding
Proceed
Repeat

I have separate reports created for each operating facility, I prefer to have all my records related to each facility listed in separate report......

Any ideas of how to write this out?

------------------------------
Kelly Lyons
------------------------------