Hi all, I am new to Appsheet and straggling days about producing a report from the table below:
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:
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
User | Count |
---|---|
35 | |
34 | |
26 | |
23 | |
18 |