# Multiple Choice duplicate data in report

**URL:** <https://community.hubspot.com/t/multiple-choice-duplicate-data-in-report/72753>\
**Category:** Dashboards & Reporting\
**Tags:** reports\
**Created:** [January 12, 2023, 12:04pm UTC](https://community.hubspot.com/t/multiple-choice-duplicate-data-in-report/72753 "2023-01-12T12:04:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![MirkoB](https://avatars.discourse-cdn.com/v4/letter/m/d78d45/32.png) [@MirkoB](https://community.hubspot.com/u/MirkoB)\
**Post date:** [January 12, 2023, 12:04pm UTC](https://community.hubspot.com/t/multiple-choice-duplicate-data-in-report/72753/1 "2023-01-12T12:04:52Z")

</div>

Hi Everybody,

i tried to build a pie-chart on a multiple-choice property, counting # of contacts of a specific phenomena, broken down by property value.

The problem is that the total #of contacts is obviously more than the true 100%, because contacts with 2 values selected count twice.  
Is there a way to make them count just once, by defining a priority criteria or something, in order to reflect the true 100%?

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [January 12, 2023, 12:10pm UTC](https://community.hubspot.com/t/multiple-choice-duplicate-data-in-report/72753/2 "2023-01-12T12:10:26Z")

</div>

Hi @MirkoB,

Not that I’m aware of, unfortunately. There aren’t any specific settings to prioritize values or deduplicate by contact for multiple checkbox properties.

If you wanted the exact numbers by a rule you define, I’d recommend creating lists for each option:

- List 1: is any of value A, is none of value B, is none of value C
- List 2: is any of value B, is none of value A, is none of value C
- List 3: is any of value C, is none of value A, is none of value B

You could then look at the list counts or create (separate) reports vizualizing the count of contacts per list.

Best regards!
