Find the biggest value

[#1]

I've a list of a few thousand items and orders.

Now I want a list all items (easy to do) that also checks the orders. But I only want to display the largest qty sold for each order

My list

Item A          Sold 20

Item A          Sold 3

Item A          Sold 60

Item B          Sold 3

Item B          Sold 3

Item B          Sold 2

Item A          Sold 45

Item C          Sold 10

Item C          Sold 15

The list should present

Item A     60

Item B     3

Item C     15

Items are found in [Art)

Sold are found in [SOLD)

[PrashantSangle · Accepted solution]

Hi,

You can create straight table in that,

take dimension->Art,

Expression->max(Sold)