Select top 10 by category

Hi there,

I have a dataset with columns Area, District and Sales. I need to get top 10 Area by Sales for all the N Districts. I could solve this using partition in SQL but this data is got by joining 2 tables and I need to set it up through Alteryx.

Thanks in advance

Workflow

Accepted answers

JoshuaGostick

Hi @Nithin_Prakash,

Try using the Sort tool to sort on each Area and District with Sales in descending order. Then, add a Sample tool, select 1 of every N rows, add 10 for N=, and group on Area and District.

Let me know if this works of if you have any questions!

Thanks,

Josh

All comments

JoshuaGostick

Hi @Nithin_Prakash,

Try using the Sort tool to sort on each Area and District with Sales in descending order. Then, add a Sample tool, select 1 of every N rows, add 10 for N=, and group on Area and District.