# Pulling Companies Based upon Contacts

**URL:** <https://community.hubspot.com/t/pulling-companies-based-upon-contacts/72888>\
**Category:** Reporting & Analytics\
**Tags:** professional\
**Created:** [January 13, 2023, 5:27pm UTC](https://community.hubspot.com/t/pulling-companies-based-upon-contacts/72888 "2023-01-13T17:27:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![BTyner](https://avatars.discourse-cdn.com/v4/letter/b/51bf81/32.png) [@BTyner](https://community.hubspot.com/u/BTyner)\
**Post date:** [January 13, 2023, 5:27pm UTC](https://community.hubspot.com/t/pulling-companies-based-upon-contacts/72888/1 "2023-01-13T17:27:01Z")

</div>

Hello,

I am looking to build a report or table that pulls all companies that have no contacts associated with them with a specific property value - the property is called “practice role”.

For example I want to pull in all companies that have no contacts associated with them that contain the property value in “practice role” for: Family Doctor or optometrist.

Thanks in advance!!

---

<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 13, 2023, 5:51pm UTC](https://community.hubspot.com/t/pulling-companies-based-upon-contacts/72888/2 "2023-01-13T17:51:47Z")

</div>

Hi @BTyner,

This type of question is best answered with two lists. The first list would be a company-based list (Menu \> Contacts \> Lists) that filters for all companies who are associated with contacts where _Practice role_ is ‘Family doctor’ or ‘Optometrist’. After creating this first list, you need to create a second list that filters for all companies which are not in the first list (filter for List membership).

Let me know if you have any follow-up questions!

---

<div class="post-metadata">

**Author:** ![AnaWilliam](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/anawilliam/32/41060_2.png) [@AnaWilliam](https://community.hubspot.com/u/AnaWilliam)\
**Post date:** [January 14, 2023, 9:44pm UTC](https://community.hubspot.com/t/pulling-companies-based-upon-contacts/72888/3 "2023-01-14T21:44:49Z")

</div>

I have a similar query, thanks for respond