2 Replies Latest reply on Dec 2, 2016 6:52 AM by Naresh Karumanchi

# Which of the four regions(E,W,S,S) has top 20 customers with the overall sales of that is 13% more than the rest of the customers?

Data source: Sample superstore.

I created a set for top 20 customers by sales and then created attached visualization with sum sales , percent of total table calculation. Except south all the remaining regions seem to have sum sales more than 13 % but this is a multiple choice question with only one possible answer.

Could you help me what am i doing wrong here? thanks!

Message was edited by: Naresh Karumanchi

• ###### 1. Re: Which of the four regions(E,W,S,S) has top 20 customers with the overall sales of that is 13% more than the rest of the customers?

Hi Naresh,

When you create a set with Top 20 by SUM([Sales]), it will give you the list of Top 20 customers across all the regions. You will have to find out the sum of sales for each customer for each region and then create a set. This way there will be only one region with 13% difference.

Please refer attached workbook for details. Hope this helps.

Thanks,

Nachiket

• ###### 2. Re: Which of the four regions(E,W,S,S) has top 20 customers with the overall sales of that is 13% more than the rest of the customers?

Hi Nachiket

Thank you very much for your kind response!!

Also, thank you very much for introducing me to INCLUDE LOD expression, This is the kind of help that i am trying to get through this forum.

They say the right answer here is the central region? But i the way you solved this problem is the right way to do it!!

Only clarification i want to ask is, as per this question we are supposed to get top 20 customers contributing 13% more than the rest in a region? if they are top 20 may be their contribution might be somewhat more than the rest, you have any comments?