Slice that includes only maximum

jwong
Participant I

I have a list of many items each of which has many quantities. I want a slice to include only the largest quantity from each unique item. Example below.

Thank you in advance!

List:
ITEM - QUANTITY
A - 5
A - 5
A - 5
A - 10
A - 20
B - 5
B - 10
B - 20
B - 30
C - 30
C - 50

Desired Slice:
ITEM - QUANTITY
A - 20
B - 30
C - 50

Solved Solved
0 3 415
1 ACCEPTED SOLUTION

Hi @jwong, hereโ€™s an app that uses a slice to solve the problem you have described. Note two things:

  1. You need a unique key for this version to work
  2. Performance may degrade at high row count or volumes.

Hope this helps!

https://www.appsheet.com/samples/Sample-App?appGuidString=8ae510b5-cb04-4622-8a07-7a1bd54b998d

View solution in original post

3 REPLIES 3

Lynn
Participant V

Hi @jwong
This is not a slice, but if you wanted a view of the items showing Max Quantity you could have a table and Group By ITEM with group aggregate as Max Quantity.


similar to this.

Also check out MAX

Hi @jwong, hereโ€™s an app that uses a slice to solve the problem you have described. Note two things:

  1. You need a unique key for this version to work
  2. Performance may degrade at high row count or volumes.

Hope this helps!

https://www.appsheet.com/samples/Sample-App?appGuidString=8ae510b5-cb04-4622-8a07-7a1bd54b998d

This worked great! thanks!

Top Labels in this Space