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:
3X_6_0_607a305505810f255a2e573c43610a3e246fc79b.png

3X_4_4_44077b2e71286edb9f959382ed071f9736a486f1.png

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

0 3 122
  • UX
3 REPLIES 3

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.

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

One more question ,

3X_9_4_94a5ded632f61220641b130ac3611b4ee24a56f0.png

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.

Top Labels in this Space