Same work flow for each region

Question

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.

Industrial.yxmd

deviseetharaman · Accepted Answer

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.