You can create waffle chart with join as well.
The negative side is increased data size, but hope it's still manageable,
Join with 1 and 1 with "Join Calculation"
Rest of process should be same.
Hi Shinichiro. thanks for providing your solution. unfortunately, this approach scales up the size of my dataset, and hence is not feasible. I will try to find a way to avoid having multiple filters altogether.
Hi Amar. Thanks for answering my question. Unfortunately, I'm not able to find relevant value filters in your submitted workbook. Could you please explain how you have obtained 'Show relevant values' in your filters?