Find the biggest value

Tue, 04 Mar 2014 15:22:54 GMT

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 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)

Re: Find the biggest value

PrashantSangle — Tue, 04 Mar 2014 15:33:43 GMT

Hi,

You can create straight table in that,

take dimension->Art,

Expression->max(Sold)