# How can I sort and sum data in different record? **URL:** \ **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:** 10\ **Page:** 1
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [August 21, 2022, 2:42am UTC](https://community.glideapps.com/t/how-can-i-sort-and-sum-data-in-different-record/47358/1 "2022-08-21T02:42:12Z")
Hi. I have data look like in attached pict. I would like to display SO, items, qty and delivered\_qty. But item should be displayed only single line not dup. How to do that? ![396659](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/c/3c6a039f253a1bc9aad7a68dfae7debdea94d500.jpeg) Regards to pict. I would like to display like. SO0001 item , qty , delivered\_qty item0001 , 42 , 0 item0002, 80 , 0 SO0002 item , qty , delivered\_qty item0004 , 11 , 1 SO0003 item , qty , delivered\_qty item0003 , 22 , 2 ---
**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 21, 2022, 3:28am UTC](https://community.glideapps.com/t/how-can-i-sort-and-sum-data-in-different-record/47358/2 "2022-08-21T03:28:00Z")
If you mean displaying it on the front end, use the “Group by” feature of inline lists (Apps)/collections(Pages). > **[Group](https://www.glideapps.com/docs/reference/ux/group)** > > Group list items into categories. Note: Doc has not been updated since “Group By” was recently added to Pages. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [August 22, 2022, 1:27am UTC](https://community.glideapps.com/t/how-can-i-sort-and-sum-data-in-different-record/47358/3 "2022-08-22T01:27:01Z")
Dear @ThinhDinh It doesn’t work like I mentioned. And it worked only single level in GroupBy. Is it possible to do a bit algorithm in the table? ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [August 22, 2022, 1:44am UTC](https://community.glideapps.com/t/how-can-i-sort-and-sum-data-in-different-record/47358/4 "2022-08-22T01:44:30Z")
Are there function like sumifs ? ---
**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")
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… ---
**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 22, 2022, 11:56pm UTC](https://community.glideapps.com/t/how-can-i-sort-and-sum-data-in-different-record/47358/6 "2022-08-22T23:56:44Z")
Ah, seems like you need to group and sum things at the same time. So please follow my comment in the link Jeff gave above and let us know if you face any problems. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [August 23, 2022, 7:00am UTC](https://community.glideapps.com/t/how-can-i-sort-and-sum-data-in-different-record/47358/7 "2022-08-23T07:00:02Z")
It doesn’t work. Because I need to get input data for querying process. I used dumb number instead. But I am thinking what happen if many specific users are querying at the same time. Does it work? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 23, 2022, 7:08am UTC](https://community.glideapps.com/t/how-can-i-sort-and-sum-data-in-different-record/47358/8 "2022-08-23T07:08:51Z")
What do you mean by “dumb number”? When ever you have multiple users viewing the same data and you need any sort of customised view per user, then you need to be using [User Specific Columns.](https://www.glideapps.com/docs/reference/basic-columns/user-specific-columns) ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [August 23, 2022, 7:23am UTC](https://community.glideapps.com/t/how-can-i-sort-and-sum-data-in-different-record/47358/9 "2022-08-23T07:23:17Z")
When user enter any data. I will put it in a new column. Let’s say dumb column. After that I use single value and if-then to check that number. As I told, I still have question if many users use this query. What will happen? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 23, 2022, 7:42am UTC](https://community.glideapps.com/t/how-can-i-sort-and-sum-data-in-different-record/47358/10 "2022-08-23T07:42:48Z")
> [@paiboolk](#): > > I will put it in a new column. Let’s say dumb column. After that I use single value and if-then to check that number. As long as that “dumb” column is User Specific, then you will have no problems with many users at the same time.