1 of 1 people found this helpful
Does the attached help? I've used superstore data and created a small excel sheet with a few customer names in to represent your secondary data source. I've used the superstore data as the primary source and put customer and sales on the column and row field and then added customer from the secondary source onto the filter and excluded nulls. This then filters the chart to only those customer which are in both data sources.
yes, that's helped a lot. Thank you.