# How can I sort and sum data in different record?

**URL:** <https://community.glideapps.com/t/how-can-i-sort-and-sum-data-in-different-record/47358>\
**Category:** Ask for Help\
**Created:** [August 21, 2022, 2:42am UTC](https://community.glideapps.com/t/how-can-i-sort-and-sum-data-in-different-record/47358 "2022-08-21T02:42:12Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [August 22, 2022, 1:48am UTC](https://community.glideapps.com/t/how-can-i-sort-and-sum-data-in-different-record/47358/5 "2022-08-22T01:48:57Z")

</div>

I think this may be what you want.

> [@Multiple "Group by"](https://community.glideapps.com/t/multiple-group-by/46950/2):
>
> What exact “bugs” were you facing? 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 t…

---

_[View the full topic](https://community.glideapps.com/t/how-can-i-sort-and-sum-data-in-different-record/47358)._