Top 5 Values of each Program CODE
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
shanparshan
5 - Atom
‎10-05-2024
05:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Everyone,
I am new to Alteryx and still in learning so pardon me if I am unable to explain things well here.
I am trying to find out the top 5 values in Each program Code and then combine them all. How can I do that? First, I have sorted the Program code Ascending and Values (Descending) order. But I need to extract the top 5 values of each program code (5 codes in Total) which I thought would be able to do with "Sample" but did not work. Can you possibly guide? I should have a total of 25 records. Thanks
V/r
Shanparshan
Labels:
- Labels:
- Preparation
1 REPLY 1
binuacs
21 - Polaris
‎10-06-2024
07:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@shanparshan the sample tool should work for your use-case, you need to select the group by option and select the field code
