Produce a Report of my undaplicated list of items

Hi all, I am new to Appsheet and straggling days about producing a report from the table below:

3X_a_d_ad394bfca40d39b65d667a29b1b9295be41e2c61.png

I need to write to my Report template a table containing only the unduplicated list of items in column [Name] and in the second column the SUM of the amount of each item in the column [amount], like this:

3X_8_0_8082acdf299910466195e78c29c3be673d19eaab.png

The best I managed to do is this: <<SORT(Unique(SELECT(Items[Name],true)))>>

But it produces one list which is not what I need: Item-1, Item-2

This can be done using other languages, such as jave, javescript, etc , so easy, but I am really finding it so hard here , can you, please, help me

0 19 438
19 REPLIES 19
Top Labels in this Space