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! Go to Solution.
Hi @jwong, hereโs an app that uses a slice to solve the problem you have described. Note two things:
Hope this helps!
https://www.appsheet.com/samples/Sample-App?appGuidString=8ae510b5-cb04-4622-8a07-7a1bd54b998d
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.
Also check out MAX
Hi @jwong, hereโs an app that uses a slice to solve the problem you have described. Note two things:
Hope this helps!
https://www.appsheet.com/samples/Sample-App?appGuidString=8ae510b5-cb04-4622-8a07-7a1bd54b998d
This worked great! thanks!
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |