I have a People table with a single select Age category (e.g., Boomer). Each person has chosen multiple Trends, which is a multiple select category linked to another table.
In the Trends table, there is a column with each Person listed. I can create a basic count of People, but am trying to segment this by age group. E.g., what are the Trend counts for Boomers?
Thank you so much for helping! I made some entertaining dummy data tables to illustrate this, but the forum won’t let me add images or links for some reason.
These are the links with the Dropbox part chopped off: