# Breakdown by multiple checkboxes

**URL:** <https://community.hubspot.com/t/breakdown-by-multiple-checkboxes/82859>\
**Category:** Reporting & Analytics\
**Tags:** enterprise\
**Created:** [June 7, 2023, 2:14pm UTC](https://community.hubspot.com/t/breakdown-by-multiple-checkboxes/82859 "2023-06-07T14:14:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![MHUSSON](https://avatars.discourse-cdn.com/v4/letter/m/b487fb/32.png) [@MHUSSON](https://community.hubspot.com/u/MHUSSON)\
**Post date:** [June 7, 2023, 2:14pm UTC](https://community.hubspot.com/t/breakdown-by-multiple-checkboxes/82859/1 "2023-06-07T14:14:10Z")

</div>

Hi,

To be concrete, I will give an example. I am using a property with multiple checkboxes. I want to create a report that will only show me certain options but I have contacts who have several of the same options.

Example: I want to know the proportion of “Anglophone” and “Francophone outside Europe” customers. Here is my data:  
- Anglophones - 75 contacts  
- Europeans - 100 contacts (of which 16 are also present in Anglophones)  
- Francophone outside Europe: 23 contacts (including 3 present in Europeans)

I applied a filter to get just the data I wanted and despite this when I break down by my property, it also displays contacts who have European property.

Can you help me on this? Is there an exclusion filter on the chart display?

---

<div class="post-metadata">

**Author:** ![TomM2](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tomm2/32/70887_2.png) [@TomM2](https://community.hubspot.com/u/TomM2)\
**Post date:** [June 7, 2023, 4:17pm UTC](https://community.hubspot.com/t/breakdown-by-multiple-checkboxes/82859/2 "2023-06-07T16:17:03Z")

</div>

Hey @MHUSSON are all of these values stored in one property? If so you should be able to build a report in the [custom report builder.](https://knowledge.hubspot.com/reports/create-reports-with-the-custom-report-builder)

It sounds like you’re doing that already however, if it’s only showing properties for Europeans, are you sure you have contacts who have property values outside of european within your timeline?  
If you have verified you have contacts who have that value in your set timline, I’d recomend checking your report filters, as there’s likely a filter for a specific value set up.

---

<div class="post-metadata">

**Author:** ![MHUSSON](https://avatars.discourse-cdn.com/v4/letter/m/b487fb/32.png) [@MHUSSON](https://community.hubspot.com/u/MHUSSON)\
**Post date:** [June 7, 2023, 4:28pm UTC](https://community.hubspot.com/t/breakdown-by-multiple-checkboxes/82859/3 "2023-06-07T16:28:07Z")

</div>

Thank you for the answer.  
Yes I have a property multiple checkboxes with all my values and I would like to break down my report with only certains of this values to know the number of contact for each of this values. But as I have some contacts with multiple values and, when I put a filter, the report show me the resultst for also all the others values in which contacts are (not just the ones I selected in my filter)

Thank you for your help !

---

<div class="post-metadata">

**Author:** ![BHarris-AU](https://avatars.discourse-cdn.com/v4/letter/b/e19b73/32.png) [@BHarris-AU](https://community.hubspot.com/u/BHarris-AU)\
**Post date:** [May 26, 2025, 3:32am UTC](https://community.hubspot.com/t/breakdown-by-multiple-checkboxes/82859/4 "2025-05-26T03:32:31Z")

</div>

I am sure that this is well and truely out of date now, but I came looking for a solution to this same problem.

For anyone else that may come across this page, this is my solution to a problem like this.

I created lists for the various options that I wanted to report on. So it might be that you have 3 lists for Anglophones, Europeans and Francophone. Then using the custom report builder, build a report based on contacts and lists and do a count of contacts (Y axis) but use list name as both the X axis and the filter.

I trust this helps