How can I sort and sum data in different record?

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?

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

If you mean displaying it on the front end, use the “Group by” feature of inline lists (Apps)/collections(Pages).

Note: Doc has not been updated since “Group By” was recently added to Pages.

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?

Are there function like sumifs ?

I think this may be what you want.

1 Like

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.

1 Like

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?

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.

2 Likes

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?

As long as that “dumb” column is User Specific, then you will have no problems with many users at the same time.