Pick the largest of a set of items

[Erick_Reyes101]

Hello,

I would like to take the following data:

SKU	anatomy2	Sum_sales
@804-03-021	KNEE	323
@804-03-021	SHOULDER	2,040
@506-03-138	SHOULDER	154,922
@506-03-138	KNEE	523
@520-50-220	SHOULDER	317,531
@520-50-220	KNEE	900

and take the largest sales value and use it to determine which anatomy should be used for the SKU:

SKU	anatomy2
@804-03-021	SHOULDER
@506-03-138	SHOULDER
@520-50-220	SHOULDER

[Prometheus · Accepted solution]

@Erick_Reyes101 The first thing I did was clean up the Sum_sales field. Because it has commas in it, it came in as a String with leading spaces. I used a Formula tool with this expression to trim and remove commas: Replace(Trim([ Sum_sales ]), ',', ''). After that, I used a Select tool to change the data type of Sum_sales to Int32, sorted descending on Sum_sales, then used the Sample tool to select First 1 why grouping on SKU. 

 

 

 

[binuacs · Accepted solution]

@Erick_Reyes101 Another method

[Erick_Reyes101]

thanks to you both! 

i think both would work for my problem, thanks for the help!