Here's one method you could try, though I'm not sure
if it will completely work for your true datasource.
I pivoted all the Painting Colors into one column using
Then I joined this sheet to the colorList on a calculated field of 1
as described here
Then I filtered out the unnecessary connections using:
[Pivot Field Values]=[Color]
Then with [Color] on the filter shelf, you can pick
multiple colors, and only those paintingIDs that contain
one of them will show.
Please see workbook attached in the Forum Thread.
273117color.twbx 32.8 KB