# Multiple "Group by"

**URL:** <https://community.glideapps.com/t/multiple-group-by/46950>\
**Category:** Ask for Help\
**Created:** [August 16, 2022, 6:33pm UTC](https://community.glideapps.com/t/multiple-group-by/46950 "2022-08-16T18:33:07Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 17, 2022, 12:24am UTC](https://community.glideapps.com/t/multiple-group-by/46950/2 "2022-08-17T00:24:07Z")

</div>

> [@djudes](#):
>
> In an effort to reduce Glide Bugs occuring

What exact “bugs” were you facing?

> [@djudes](#):
>
> The raw data contains 2 rows for each store, so doing a simple relation to the raw data would still give me multiple results per store.

You can sort of do a “unique” setup in Glide.

- Create a rowID column for the first table.
- Create a relation from the Store column to itself, make it a multiple match.
- Create a single value column on top of the relation above, returning the rowID from the first match.
- Create a rollup column on top of the relation to count the number of orders.
- Show the inline list of the first table, filter by rowID is the same as the “first match” rowID in step 3. Display the count from step 4.

---

_[View the full topic](https://community.glideapps.com/t/multiple-group-by/46950)._