Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Top 5 Values of each Program CODE

shanparshan
5 - Atom

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

1 REPLY 1
binuacs
21 - Polaris

@shanparshan the sample tool should work for your use-case, you need to select the group by option and select the field code

image.png

Labels
Top Solution Authors