Same work flow for each region

[cwilcoxmtn]

I need to complete the same process for every different region.  I need the total top 10 customers in sales for 1) Current Month, 2) Past Year Current Month, 3) YTD 2020 and 4) YTD 2019.

I need these 4 variables for each of the Regions. 

I know there has to be a simpler way to do it, than to filter out each region and run the top 10 and join them all back together, but can't seen to find it.

[deviseetharaman · Accepted solution]

Hi @cwilcoxmtn 

You can include region in the summarization tools and then group by Region in sample tool. this will give up top 10 customers for each region. If you can provide the input spreadsheet, then we can provide the required workflow.

[cwilcoxmtn]

I found what you suggested. . Thank you. . That was the solution I needed.  I knew there was something I was missing.