Group by Item and sum quantities

[thiago_tcr]

Hello!

I have a table with itens listed one by one. is there any way I can group them and also sum it´s respective quantities?

Like this:

[thiago_tcr]

Just an update,

I was able to sum the values with a virtual column:

SUM(SELECT(TABLE[QTDE],[ITEM_ID]=[_THISROW].[ITEM_ID]))

Now i need to aggregate the items.

Thanks for any help!

[Joseph_Seddik]

You don’t to create additional columns for this. This can be directly achieved through the UX view. See this:

Control grouping - AppSheet Help