yup so I can't use the multi-select filter since it would limit the rows to what is just selected:
Using multi-select filter:
The requirement for the worksheet is to answer a question like 'after purchasing a phone/TV what is the next likely purchase of these customers?' or 'what did the customers bought along with phone/TV?'
So on below screenshot, so we can answer that they also bought Accessories along with the two categories and are likely to buy more of those 3 more categories in the succeeding purchases.
But the problem with this solution I posted is it is extremely slow when working with large datasets (2m+ rows) and it takes about 15min to load on tableau server when applying the filters.