# Flip recursive group by in table

**URL:** <https://community.fibery.io/t/flip-recursive-group-by-in-table/7474>\
**Category:** Get Help\
**Created:** [September 30, 2024, 3:23pm UTC](https://community.fibery.io/t/flip-recursive-group-by-in-table/7474 "2024-09-30T15:23:20Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![tycecycle](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@tycecycle](https://community.fibery.io/u/tycecycle)\
**Post date:** [September 30, 2024, 3:23pm UTC](https://community.fibery.io/t/flip-recursive-group-by-in-table/7474/1 "2024-09-30T15:23:20Z")

</div>

I don’t love the title for this post, but hopefully an explanation will clarify. I have a database named “Company” with a relation field called “Contractor” that self-references the Company database. I create a new table view for the Company database. I’d like to have each “Company” as the top level grouping, and see all the related contractors grouped under each company.

However, the only grouping I’m able to produce is “Contractor” as the top-level grouping.

Am I thinking about this problem wrong, or is something like this just not possible in Fibery right now?

I’ve annotated some screenshots to show what I’m trying to accomplish as well.

 ![Screenshot 2024-09-30 at 11.08.50 AM](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/c/cf68848b42faca59598d7959287ec8f8e51c26f6.png)  
 ![Screenshot 2024-09-30 at 11.08.28 AM](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/b/bd4a9293b558221cbda0fe7947eac514e678b17a.png)

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [September 30, 2024, 4:40pm UTC](https://community.fibery.io/t/flip-recursive-group-by-in-table/7474/2 "2024-09-30T16:40:12Z")

</div>

When you open the dropdown to choose the database to Group by, you should see both ends of the many-to-many relation.  
What is the name of the corresponding field that is the other direction to Contractor?

---

<div class="post-metadata">

**Author:** ![tycecycle](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@tycecycle](https://community.fibery.io/u/tycecycle)\
**Post date:** [September 30, 2024, 5:17pm UTC](https://community.fibery.io/t/flip-recursive-group-by-in-table/7474/3 "2024-09-30T17:17:53Z")

</div>

It’s vendor, and that was totally the issue 🤦‍♂️. Thanks!

---

<div class="post-metadata">

**Author:** ![tycecycle](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@tycecycle](https://community.fibery.io/u/tycecycle)\
**Post date:** [September 30, 2024, 5:33pm UTC](https://community.fibery.io/t/flip-recursive-group-by-in-table/7474/4 "2024-09-30T17:33:39Z")

</div>

Actually, that’s still not quite behaving as expected. It doesn’t seem to be grouping by Vendor, which would be the same as the Name Field.

 ![Screenshot 2024-09-30 at 1.32.13 PM](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/3/361bc0759a1d306cd2f6fec158e1aa99c95026f2.png)

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [September 30, 2024, 5:50pm UTC](https://community.fibery.io/t/flip-recursive-group-by-in-table/7474/5 "2024-09-30T17:50:27Z")

</div>

What filter do you have applied?

---

<div class="post-metadata">

**Author:** ![tycecycle](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@tycecycle](https://community.fibery.io/u/tycecycle)\
**Post date:** [September 30, 2024, 9:31pm UTC](https://community.fibery.io/t/flip-recursive-group-by-in-table/7474/6 "2024-09-30T21:31:52Z")

</div>

🤦‍♂️ 🤦‍♂️ 🤦‍♂️

A filter that hid the grouping by vendor behavior.

It points to the fact I need to think differently about how to create this view, but everything is working as expected.