Max, min, average record

Question

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 Answer

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.