Sort+Group Relationships

I know I saw this recently discussed in the community just cannot find it now.

I have a table with over 2-3k rows of order items & qty

ItemName - QTY
ItemA - 3
ItemB - 50
ItemA - 2
ItemC - 10
ItemA - 4
ItemB - 7

what is the best way to group them according to Item Name
ItemA - 9
ItemB - 57
ItemC - 10

there are over 1000 different item names

Is this to display in a list?

What I would do is first make sure you have a Row ID column. Then create a multiple relation that links the item name to itself. Using that relation, create a rollup column that sums the total quantity for each item. Then create a Single Value column that grabs the Row ID value from the relation (This will be the first matching row ID for that item name). Finally create an IF column then checks if the single value row ID matches the regular row ID. If it does, then return the rollup quantity. Now you can filter you list by checking if that IF column value is not empty, and it will provide a list of unique items and their total quantity count.

4 Likes