Find the biggest amount
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
abardaje
8 - Asteroid
‎07-05-2022
08:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
Can someone please help me on how to get the biggest amount from my attached sample.
Attached is for the sample : Input tab is the sample data while the output tab is the result I want.
Thank you!
Labels:
- Labels:
- Tips and Tricks
4 REPLIES 4
binuacs
21 - Polaris
‎07-05-2022
08:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
17 - Castor
‎07-05-2022
08:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @abardaje,
You can just use a summarize and a join tool like this:
Any questions or issues please ask :)
HTH!
Ira
ACE Emeritus
‎07-05-2022
08:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can use the Summarize tool as I have shown here and then filter out the Jewelry after that.
‎07-05-2022
12:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you all :)
