Find and Highlight the Maximum value per each category of a field

[PNiccolo]

Hi everyone!

I currently have a table that looks like this:

Plant	Item	Inventory Value
Plant A	Item X	10
Plant A	Item Y	12
Plant A	Item Z	11
Plant B	Item X	5
Plant B	Item Y	3
Plant C	Item X	4
Plant C	Item Y	5
Plant C	Item Z	7

What I would like to do is to create a tool to automatically highlight, or make somehow understand, which is the item with the maximum inventory value for each plant.

Do you know a way to do it?

Thanks a lot!

[Thableaus · Accepted solution]

Hi @PNiccolo 

Group by Plant and use Max on the Inventory Value, with the Summarize Tool.

You can them join it back to your dataset by Plant and Inventory Value to get the Item, if you want.

Cheers,

[Thableaus · Accepted solution]

@PNiccolo 

Another way of doing it would be using the Sort Tool + Sample Tool.

The Sort Tool would sort your Plant and Inventory values by Descending, then you could use the Sample Tool to get the 1st value grouping by Plant.

Cheers,  

[Thableaus]

@PNiccolo 

Both of ways to do this in the WF attached.

[Amin]

Tested both approaches, works wonderfully.

Just a caution for the Sort Tool + Sample Tool approach:

When there is more than 1 maximum types (e.g. both apples are oranges are maximum for a fruit shop), only one will be reflected.

As such, I will prefer the Summarize and Join approach earlier by @Thableaus.