I will add to the question that we are looking for some response which is dynamic in nature, as our actual dataset could result in 1.7 billion unique combinations.
Hi John & Gregory,
I downloaded the workbook and took a peek. This seems like a variation on a market basket analysis. Check the attached workbook which seeks to answer the question using a Self-Join and quick filters. Second attached wordbook does the same with parameters and calcs, no join.
Was the highlighting part of the necessary solution?
Edit: Calc used int he second workbook:
IF [Product Sub-Category]=[First Category] OR [Product Sub-Category]=[Second Category]
THEN "Focus Categories" ELSE "Other Categories" END
Thanks Dustin, we’ll have a look; definitely a form of a Market Basket Analysis.
GBS – Business Intelligence
There are many methods to get to the results you described, is the attached closer to what you are looking for?
In the attached there is a parameter to set the min items that you need, eg if you want categories with at least 2 containers, and you filter with the action (or a normal multi-select quick filter) two or more, you will get categories that have two or more containers.
Superstore Example jm edit.twbx.zip 433.0 KB