7 Replies Latest reply on Nov 12, 2014 6:07 AM by KK Molugu

# pareto labeling

Hi guys, if you go through the attached picture, Is there a way to get rid of those percentage values on the graph? or may be get only critical values labelled when there is a major change in the graph?

• ###### 1. Re: pareto labeling

John:

It is possible to hide the labels in the view. Click [Abc] in the tool bar. It is also possible to only show when there is a major change (we need to define Major change).

..kk

• ###### 2. Re: pareto labeling

Yes, you can go to marks-labels and uncheck "show mark labels" or select other options for showing them i.e. max/min.

1 of 1 people found this helpful
• ###### 3. Re: pareto labeling

John:

Here you go with an example to show conditional labels (in the example I used change since last qrt > 25%) and hope this helps;

..kk

1 of 1 people found this helpful
• ###### 4. Re: pareto labeling

Thanks for the quick reply guys i got one more question is it possible to list those top 1% or top 10% of customers in pareto analysis ?

• ###### 5. Re: pareto labeling

John:

Glad it helped. What do you mean by top 1% or 10% in Pareto?

..kk

• ###### 6. Re: pareto labeling

if we do a pareto analysis and find you that 10% of customers consitute for the 90% of the sales . How do we list those 10% customers .

• ###### 7. Re: pareto labeling

John:

If you want to highlight the top x% customers who constitute to y% of sales, there are couple options.

Use this sample formula that shows categories which constitutes 60% of the sales;

if RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales])) < .6 then "Show" Else "Hide" end

- Highlighting - Show the x% categories with diff color

- Filter - Only show the x% categories

Hope the attached workbooks helps;

..kk

1 of 1 people found this helpful