Hi Jenny,  did you ever get an answer to this question?  If you're still running into limitations re. filtering - check out our app, Akoonu for Pipeline Reviews. You can filter by any field on the opportunity (or related or child objects, including those on campaign or product). Check out the test drive feature to see the app in action, with data, without having to install in a sandbox first - https://appexchange.salesforce.com/appxListingDetail?listingId=a0N3A00000EcyXzUAJ