Hi,
My data set is a list of products from two different vendors. Some of the products are found in both vendors. These are the items that I want to filter for.
I want to create a calculation or parameter that will allow me to filter for just items that have matching Vendor Part Number AND Manufacturer Name. All other dimensions do not have to match.
Below is a sample of my data and my Tableau workbook. On the Excel sheet, the items highlighted are items I would want to filter for being that they have have matching Vendor Part Numbers and Manufacturer Names.
Chris,
I think I was able to do this with an EXCLUDE LOD.
Check this out:
This sums the number of records (without taking into account description or vendor, i.e. at a higher level of aggregation than the table)
That leaves you with a table like this:
At this point, all you need to do is add a filter on the calculation we built above where #Records > 1, and that will leave you with just the records you care about:
Let me know if that helps!
Derek
