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:
Any ideas on how to go about calculating something like this out?