Summarize Max volume and get price

[TomCurran]

I need to get the price from the max volume for market, brand, and size. I have this solution and have checked it, but I question whether or not this actually is the way to go about this.

[BenMoss · Accepted solution]

It appears to work fine!

An alternative would be to use the sample tool after your sort. Grouping by Market, Brand and Size and returning the last 1 record.

What i'd be most wary of is what happends if you have a combination which has the same volume but a different price, is that possibe?

See attached.

Ben

[TomCurran]

Ben,

Thank you, and yes I was concerned about a combination which has the same volume, but I have to check with my requester as to how he would like to handle that case.