# Ticket category report issue with multiple select properties

**URL:** <https://community.hubspot.com/t/ticket-category-report-issue-with-multiple-select-properties/126916>\
**Category:** Tickets & Conversations\
**Tags:** help-desk\
**Created:** [February 26, 2025, 3:33pm UTC](https://community.hubspot.com/t/ticket-category-report-issue-with-multiple-select-properties/126916 "2025-02-26T15:33:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![K\_Gronvang](https://avatars.discourse-cdn.com/v4/letter/k/bc8723/32.png) [@K\_Gronvang](https://community.hubspot.com/u/K_Gronvang)\
**Post date:** [February 26, 2025, 3:33pm UTC](https://community.hubspot.com/t/ticket-category-report-issue-with-multiple-select-properties/126916/1 "2025-02-26T15:33:07Z")

</div>

Hi

I have currently set up a way to categorize our tickets by using multiple properties that are intended to contain options with different levels of granularity/detail of the topic of the ticket, but now I have run into some issues with the reports that I am able to generate from this.

Note: I’m fairly new to both Hubspot and support ticketing systems.

**What I have done:**

I have 3 properties for ticket categorization (_type_, _category_, _sub-category_) each intended to have a different level of granularity/detail to describe the topic of the ticket.

All properties are multiple select properties.

For _category_ and _sub-category_ I have used the “conditional property options” functionality so that depending on which options in _type_ has been selected only some of the options for _category_ can be chosen, and the same relation has been made between _sub-category_ and _category_. This does so that only _sub-categories_ that are relevant to the selected _types_ and _categories_ can be chosen, which is what I wanted for ease-of-use when filling out the properties.

**The issue:**

I am now trying to create a report that shows the ticket count for each _category_ but only for the _categories_ where option 1 has been selected in _type_. And here I seem to run into issues when multiple options have been selected in _type_ and _category_.

Example:

Say _type_ has options ‘a’, ‘b’, ‘c’ and _category_ has options ‘d’, ‘e’, ‘f’, ‘g’, ‘h’, ‘i’. And the the conditional property options creates the following relation between the property options.

Type: a b c

\_|\_ \_|\_ \_|\_

Category: d e f g h i

If a ticket then has selected ‘a’ and ‘b’ in _type_ and ‘d’ and ‘f’ in _category_ then I can’t seem to figure out how to create a report with a graph showing ticket count per category but only showing the counts for the _category_-options ‘d’ and ‘e’.

**Questions:**

Based on the example; when I have a report that displays ticket count per category and I filter for _type_=a it still shows the count as 1 for both ‘d’ and ‘f’, but I don’t want ‘f’ to be on the graph at all.

Is there a way to filter away some of the options of a multiple select property in a report graph?

Have I used Hubspot in an incorrect way? Is there another structure/setup that would allow me to accomplish what I want?

---

<div class="post-metadata">

**Author:** ![PamCotton](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/pamcotton/32/47916_2.png) [@PamCotton](https://community.hubspot.com/u/PamCotton)\
**Post date:** [February 26, 2025, 11:38pm UTC](https://community.hubspot.com/t/ticket-category-report-issue-with-multiple-select-properties/126916/2 "2025-02-26T23:38:52Z")

</div>

Hey [@K\_Grønvang](https://community.hubspot.com/t5/user/viewprofilepage/user-id/906476), thank you for posting in our Community!

Currently, [HubSpot reporting includes all selected values in multi-select properties](https://knowledge.hubspot.com/reports/create-reports-with-the-custom-report-builder), so filtering by **Type = ‘a’** still shows tickets with other types.

You can’t directly filter out specific values within a multi-select field in reports. A workaround is using lists, custom properties, or workflows to tag tickets where Type only contains ‘a’. I would highly recommend you to please post this idea at our ideas forum ([**here**](https://community.hubspot.com/t5/custom/page/page-id/ideaslandingpage)).

Let me know if you need more details!

Pam