Allocations "To be picked up" by club type

Is there a way to run a report that will tell me how many orders need to be picked up for each club level. Thanks

I have a saved report that we use for orders not picked up that could probably be used for this. It’s under Sales Reports --> Orders by number. Add the filter for Shipping status and check the box for “not picked up” then there is a column in the report for the club so you could sort by that.