Max value of string fields based on integer field

[JPri]

I am trying to return the max string value in a dataset where location may be different, but each line is part of same group. I would like to return the location that has incurred the most amount, compared to total.

For example, below would be like the data I have to manipulate and the smaller box is what I would like it to return. So, they are all part of group A, but because USA has amount of 200 out of 300, this should return as max country (same logic applied to 'Type'), but the total amount for A would be 300. 

Can anyone help to figure this out? 

Data:
Group	Country	Subject	Amount
A	USA	Robotics	100
A	France	Robotics	100
A	USA	Media	100
Trying to achieve:
Group	Max of Country	Max of Type	Amount
A	USA	Robotics	300

Also, is there a filter that I can apply that would show all countries without duplicating any of them: 

Group	Countries involved	Max of Type	Amount
A	USA, France	Robotics	300

[Kenda · Accepted solution]

Hey @JPri!

See if the attached workflow gets you the output you're looking for.

The left Browse should be your first request with the Max Country, the Max Subject, and the grand total. The right Browse will return your second request with all countries involved with the Max Subject along with the grand total amount. 

Hope this helps!

[ponraj · Accepted solution]

Here is the sample workflow for your case.  Hope this is helpful. 

WorkflowInputResults

[JPri]

Thanks both!