I have a multi-select column I'm trying to count instances of for each quarter of each year. I created a make-shift report using a sheet and I'm looking for help to determine if there's a better way to do this.
Report I created:
I've duplicated that sheet into more columns so I could share the formulas I am using. The left side is the actual report I created (see first screenshot). It's saved as a sheet and not as a report because I can't figure out how to do this any other way.
This is what the report looks like now and I'm trying to determine if I've done it the best way (screenshot of above link):
Here's the sheet with the source data:
Notice that the "Business Owner Status", where we are doing our lookup on, is a multi-select column and often has multiple values in it.
Can anyone give me a better way to display this data IN THIS FORMAT using dashboard or a report?