# Cleanly report on multiselect properties **URL:** \ **Category:** Reporting & Analytics\ **Tags:** reports, workaround, how-to\ **Created:** [June 26, 2025, 9:18pm UTC](https://community.hubspot.com/t/cleanly-report-on-multiselect-properties/135285 "2025-06-26T21:18:33Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![PHA\_iPadag](https://avatars.discourse-cdn.com/v4/letter/p/ce73a5/32.png) [@PHA\_iPadag](https://community.hubspot.com/u/PHA_iPadag)\ **Post date:** [June 26, 2025, 9:18pm UTC](https://community.hubspot.com/t/cleanly-report-on-multiselect-properties/135285/1 "2025-06-26T21:18:33Z")
Good afternoon- Trying to figure out how to handle situations like this in HubSpot’s reporting. It’s becoming a recurrent issue so I’d like to learn what the fix might be for it. The report in the picture has a Secondary Product multi checkbox field. Some of our deals might sell both cabinet refacing and countertops while others might sell one or the other. We have other primary and secondary products where this type of grouping is common. The recurring issue is that HubSpot is counting a product inside of each secondary category it’s selected in. The total count of deals is 10. There are only 3 Cabinet Refacing, 3 Cabinet Refacing & Countertops, and 1 Countertop deals. I know that making secondary category a single dropdown select would fix this but due to the nature of the business, a deal can have any number of combinations so making an option for every single permutation seems cumbersome. Is there a way to get HubSpot to report on those multiselect deals more cleanly? I.E. Separating those Cabinet & Countertop deals from the sole Cabinet or sole Countertop amounts/counts? ![PHA_iPadag_0-1750972093162.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/1/c/1c35afa065c98fd960e5b1cd1b559c22ba416c72.png) Thanks for the insight! Cheers! ---
**Author:** ![CarolinaDeMares](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/carolinademares/32/22707_2.png) [@CarolinaDeMares](https://community.hubspot.com/u/CarolinaDeMares)\ **Post date:** [June 27, 2025, 1:09am UTC](https://community.hubspot.com/t/cleanly-report-on-multiselect-properties/135285/2 "2025-06-27T01:09:24Z")
Hi [@PHA\_iPadag](https://community.hubspot.com/t5/user/viewprofilepage/user-id/936072)! I know how overwhelming should this be - have you tried custom properties to categorize combinations? Here’s how I would do it: Create a calculated text or dropdown field via workflow that labels deals like: - “Cabinet Refacing only” - “Countertops only” - “Cabinet Refacing & Countertops” - “Other combinations” Then, use this new field for reporting instead of the multi-select. This adds a layer of classification and prevents overlap. Hope it helps! [Carolina De Mares](https://www.linkedin.com/in/carolina-de-mares/) ![CarolinaDeMares_0-1744137610972.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/9/96bd33c2144bb420111514e8bddb94217a1e90ce.png) [**Brandgang**](https://www.brandgang.com/contact) Goirkekanaaldijk 14 5046 AT Tilburg ---
**Author:** ![PHA\_iPadag](https://avatars.discourse-cdn.com/v4/letter/p/ce73a5/32.png) [@PHA\_iPadag](https://community.hubspot.com/u/PHA_iPadag)\ **Post date:** [June 27, 2025, 1:16pm UTC](https://community.hubspot.com/t/cleanly-report-on-multiselect-properties/135285/3 "2025-06-27T13:16:27Z")
Hi Carolina! Thanks for responding. I think I saw a suggestion similar to your recommendation on another post. Either with custom properties or by putting those records in a list. Both options feel like they kind of do the same thing as having the single dropdown for all possible product combinations but I’ll give it a test in our sandbox. Thank you! ---
**Author:** ![franksteiner79](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/franksteiner79/32/34443_2.png) [@franksteiner79](https://community.hubspot.com/u/franksteiner79)\ **Post date:** [June 27, 2025, 4:03am UTC](https://community.hubspot.com/t/cleanly-report-on-multiselect-properties/135285/4 "2025-06-27T04:03:30Z")
Hi [@PHA\_iPadag](https://community.hubspot.com/t5/user/viewprofilepage/user-id/936072), Few questions before I’m making any recommendations: So the secondary product is a deal property? What exactly do you want to report on? Any particular reason you are using deal properties instead of products/line items? ---
**Author:** ![PHA\_iPadag](https://avatars.discourse-cdn.com/v4/letter/p/ce73a5/32.png) [@PHA\_iPadag](https://community.hubspot.com/u/PHA_iPadag)\ **Post date:** [June 27, 2025, 1:33pm UTC](https://community.hubspot.com/t/cleanly-report-on-multiselect-properties/135285/5 "2025-06-27T13:33:35Z")
Hi Frank! 1. I was using the term deals in my original post but this is actually a custom object for “Jobs” or projects that our business is working on. The object is suppose to help our accounting keep track of jobs, their status, and money across multiple companies. 2. Both the primary and secondary product properties live on that Jobs custom object. My manager is looking for a report that specifies when a Job is a Cabinet job v. Countertop job v. Countertop & Cabinet job. As I mentioned in the initial post, we have a lot of possible combinations for products so the secondary product field being multiselect was our way of trying to account for that. Another example might be for a different company of the business where we would want to look at counts for the following: Soffit, Fascia, Gutters, Soffit & Fascia, Soffit & Fascia & Guttering, Soffit & Guttering, etc. In that example, the duplicates start to become even harder to parse out. 3. We’re still new to HubSpot (4 months in) and I recently got asked to help with building things out in HubSpot in regards to properties, reports, etc. My understanding is that at some point, we tried to use Line Items and the Product Library to keep track of this. We had issues with using products for a similar issue that we are using a multiselect for secondary product which is the sheer volume of options per product. I had asked the same question but was told that for example, our Cabinet Refacing catalog would be 100s of products on it’s own based on Color, Wood Type, etc. Sorry for the long blurb but I hope that clarifies things up. Otherwise, happy to provide more information about the situation and needs. Thank you! ---
**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:** [June 27, 2025, 4:21am UTC](https://community.hubspot.com/t/cleanly-report-on-multiselect-properties/135285/6 "2025-06-27T04:21:50Z")
Hi [@PHA\_iPadag](https://community.hubspot.com/t5/user/viewprofilepage/user-id/936072), What’s your ideal behavior in this report if you don’t want all options to reflect with the value of 1? Should a second option not display at all in the report? Should it display but with value 0? I think HubSpot handles it the exact way it does, because, while slightly inconvenient, it’s the most logical way to approach this. If you just want a primary value to display, a workflow solution makes the most sense. You would create a dropdown property with the same values, then have a workflow that re-enrolls records where the checkboxes property is known, then use a branch to check which values is known and copy it into the dropdown. The order of the branch paths determines their priority. Alternatively, approach the entire topic differently and create one report per product. The reports would be overlapping but in each report, each deal would only show once. Best regards! ---
**Author:** ![PHA\_iPadag](https://avatars.discourse-cdn.com/v4/letter/p/ce73a5/32.png) [@PHA\_iPadag](https://community.hubspot.com/u/PHA_iPadag)\ **Post date:** [June 27, 2025, 1:47pm UTC](https://community.hubspot.com/t/cleanly-report-on-multiselect-properties/135285/7 "2025-06-27T13:47:53Z")
Hi Karsten! Ideal behavior would be that the report shows the combinations on their own row. E.G. Cabinet on it’s own row, Countertops on another, and those different combinations on their own separate rows. I understand that this is really more a limitation on how we’ve built the property on multiselect but as mentioned in my post, it was to try to account for the number of possible combinations on our products that a customer might choose without having to create an option for every single combination. I’ve cropped it off of my initial screenshot but there is a Primary value already displaying for the report with the main product category. The secondary product field is how we’re attempting to get drill down details about what products, or combination of products, our customers are purchasing. I’ll attach the report showing the primary product display to my reply. Essentially what I’m asking is: Is it possible for us to report on the different combinations selected inside of a multiselect property on individual rows? So a breakdown by row of records where only Cabinets was selected, records where only Countertops is selected, and records where it’s Cabinets;Countertops. Thanks for your time and appreciate your insight! ![PHA_iPadag_0-1751031776299.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/d/d9328c45ece40f95f925a07eced75087d118ac14.png) ---
**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:** [June 27, 2025, 1:49pm UTC](https://community.hubspot.com/t/cleanly-report-on-multiselect-properties/135285/8 "2025-06-27T13:49:30Z")
> * * * > > [@PHA\_iPadag](https://community.hubspot.com/t5/user/viewprofilepage/user-id/936072) wrote: > > Essentially what I’m asking is: Is it possible for us to report on the different combinations selected inside of a multiselect property on individual rows? So a breakdown by row of records where only Cabinets was selected, records where only Countertops is selected, and records where it’s Cabinets;Countertops. > > * * * … only by combining the information of the different checked boxes in, for example, a single-line text property, unfortunately. ---
**Author:** ![PHA\_iPadag](https://avatars.discourse-cdn.com/v4/letter/p/ce73a5/32.png) [@PHA\_iPadag](https://community.hubspot.com/u/PHA_iPadag)\ **Post date:** [June 27, 2025, 1:52pm UTC](https://community.hubspot.com/t/cleanly-report-on-multiselect-properties/135285/9 "2025-06-27T13:52:21Z")
Got it, that’s kind of what the case was seeming like. If that’s the case, some kind of workflow to label these things like you and Carolina suggested might be the best path forward. Again, I appreciate your time on helping me work through this. Thanks again!