6 Replies Latest reply on Jun 2, 2016 2:54 AM by Rajesh L M

# Need help in getting top/bottom N Customers for profit in scatter plot

Hi Guys,

I have a scatter plot with sales and profit across customers,Need help in getting top/bottom N Customers for profit.

with single measure(bar graph) its working fine but not able to replicate same logic with scatter plot.

i have attached the sample store workbook.

Pls help me in resolving this issue.

Thanks,

Rajesh

• ###### 1. Re: Need help in getting top/bottom N Customers for profit in scatter plot

Howdy Rajesh,

Previously when you used a bar graph you had your customers in the view in such a way that the bars were aligned horizontally with each other. Table calculations (your rank is a table calc) by default usually run across a table or down a table. When customer name is in the rows shelf or columns shelf this logic easily applies.

Now in your case your customer name is on the details shelf and so running across a table or down the table will do nothing. In fact if you drag your ranking calculation onto the labels shelf you will see that everyone has the same rank.

To solve this right click your 'Top/Bottom' ranking calculation on your filters shelf and go down to 'compute using'. Then select 'Customer Name'. This tells it to rank based on the customers in the details shelf instead of what it finds in the table by looking across.

Cheers!

Carl Slifer

InterWorks

1 of 1 people found this helpful
• ###### 2. Re: Need help in getting top/bottom N Customers for profit in scatter plot

Hi Rajesh,

Top

Bottom

Thanks and Regards,

Ashish Chaudhari

• ###### 3. Re: Need help in getting top/bottom N Customers for profit in scatter plot

Great Explanation Carl.

• ###### 4. Re: Need help in getting top/bottom N Customers for profit in scatter plot

Hi Rajesh,

This is just FYI, if you fail to understand compute using what you can do is follow the below steps.

Create a simple crosstab as below.

Then put you boolean field in the filter section which will prompt you true and false. Select true in this case.

Go Ahead and click on scatter from "SHOW ME" button.

and its done.

PS: I used this method.

Thanks and Regards,

Ashish Chaudhari

• ###### 5. Re: Need help in getting top/bottom N Customers for profit in scatter plot

Wonderful explanation Carl.

Thanks a lot.

• ###### 6. Re: Need help in getting top/bottom N Customers for profit in scatter plot

Thanks Ashish for the detailed steps