How to view the number of value

Hello.
I am new to using appsheet and sometime i am a little lost with simple features…
I have the following data where i scan barcode of articles one by one to create a parcel:

this is my view now.

I would like a view with one line per article with the amount of article

before:

article:
800800
800800
800800

after:

article // amount
800800 // 3

thank you very much

Florian_LINDENLAUB:

I would like a view with one line per article with the amount of article

The view you are showing is a Table View that is Grouped by the column “Named Parcel”.

You could create a copy of that Table View, Group it by “ID Item” and also include the Aggregate function COUNT (shown in image below). Not only will you have the COUNT but then you drill into that Grouping and see the rows that contribute to that count and/or see additional details.

2 Likes

Very nice! Thank you very much for you help Willow, i appreciate !

One more question ,

it works, i have though blank line corresponding to the number of articles.
How can i remove those blank line?
thankyou, have a good day

Add a second grouping Item for the [_ROWNUMBER]. This forces another visual grouping level. Note that if you click on the Grouping row it will display the row(s) that contribute to the Group. Use this to your advantage to show row details of the items that are part of the group.

1 Like