I have data with number of specialty categories (400+) that our customers can fall into. Each customer has a unique ID and can fall into multiple categories. I'd like to create a dashboard that shows the count of individuals overlapping in multiple categories. In my mind it would have be a heat map grid similar to the following:
|Category X||Category Y||Category Z|
Any ideas on how to go about calculating something like this out?
Also want to clarify, the Category Field is a single dimension in the workbook.