Try to use the filters from your primary source. In data blending filter works from primary data source.
Would it be possible to add a packaged workbook?
Unfortunately a data blending filter only allows you to view one variable at a time, but this is definitely heading in the right direction.
I'm currently creating a source document to create a bridge between the data. I'll try and upload a packaged workbook sometime next week.
Really appreciate your response,