Max, min, average record

[skeen503979]

Hello, 

I need to search a large data set of sales data to identify the order with the max, min, and average QTY of sales.  I've used the Summary tool to identify the value of those Max/Min/Average values, however, I don't know the order number they relate to.

How can I identify this?

[apathetichell · Accepted solution]

group by order number in your summarize tool.

If you add a group-by order number at the top of your summarize tool but keep the min/max/average (or average non-null) entries you'll get the information you are looking for grouped by order number.  If there are multiple characteristics to the order number you can add secondary identifiers and group by them as well.

[DylanDowrick]

I believe you can use a Sort > RecordID > Filter (RecordID=1) for each of your desired max/min/avg and then union together.