I am doing work for a non-profit organization.
I have the following tables:
Members (company name, address, etc)
SocialMedia (FB, IG, YT, etc) <-- links to Members
Type (Potential, Regular, Associate etc) <-- links to Members
The SocialMedia table has a count field that totals how many Members have each SM platform. It looks something like this giving me the total of all Member types:
FB - 111
IG - 50
TY - 75
I would like a script that allows me to see the SocialMedia COUNT by Type. It can be either a group or filter option as long as I can see something like below.
FB - 10
IG - 5
YT - 3
FB - 15
IG - 6
YT - 5
FB - 7
IG - 3
YT - 0
Thank you for any direction you can offer.