Max value of string fields based on integer field
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
- Labels:
- Preparation
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks both!