Report to count only if 'yes' is the value across multiple fields
We have a number of Opt-in fields that record different customer preferences. e.g. does the customer want to receive (field 1) Brochures - Yes/No, (field 2) SMS - Yes/No, (field 3), Emails - Yes/No. We then have a separate menu field for a product dimension (A or . Obviously the two are not actually related in the system, but they can be loosely correlated as you can only be interested in A or B at any one time. So I can select that I am interested in Brochures and Emails for Product A.
I've been asked to build a report that shows the number of contacts who have selected Yes (in this case, optin yes) for each preference. Output expected is: