Pareto Analysis to show Top 5 and their contribution?

[dmohanty]

Hi All,

I have a requirement to show the Top 5 products in a Pareto Analysis format and their contribution in terms of percentage.

The sales of Top 5 can be displayed by this formulae:

Sum({<Products = {"=Rank(sum(Sales ))<=5"}>} Sales )

But how to show their contribution in terms of percentage?  Please help

Here is my sample data below:

Load * Inline
[
Products, Sales
Soap, 1000
Shampoo, 1800
FaceWash, 2000
Moisturizer, 1200
Deodorant, 1600
Perfume, 800
Toner, 600
HairGel, 400
Conditioner, 1400
Sunscreen, 1500
]

;

[Colin-Albert]

Sum(Sales) / sum( total Sales)

[SergeyMak]

Hi,

to show only top 5 you can use dimension limits

And to show the perc you can use the following expression

Sum(Sales)/Sum(TOTAL Sales)

and select Integer and Show in percent (%) on Number tab

[MK_QSL · Accepted solution]

SUM({<Products = {"=Rank(SUM(Sales),4)<=5"}>}Sales)/SUM(TOTAL Sales)

Go to Number Tab and Tick Show in Percent %

Update : Check Enclosed File..

[jagan]

Hi,

Try this expression

=Sum({<Products = {"=Rank(Sum(Sales)/ Sum(TOTAL Sales))<=5"}>} Sales ) / Sum(TOTAL Sales)

Regards,

Jagan.

[bertdijks]

Simplest way is to

1. use the dimension limit
2. use the expression sum(Sales)
3. and check the 'Relative' checkbox at the expression tab.

See attached example

Hope this helps.

Bert

[dmohanty]

Hi All,

Thank you a lot to all of you helping here. I was able to get my desired solution.

Also, I was showing the Accumulated Sales % (just like mentioned in Pareto Analysis Blog of Henric Cronstom). Now I want to show two Referal Lines (black dotted line): one for Top 5 and other for Top 10. How can I show it dynamically?

Here is the image below:

[SergeyMak]

Hi,

You just need to put the strings

Min({<Products = {"=Rank(SUM(Sales))<=5"}>}Sales)

and

Min({<Products = {"=Rank(SUM(Sales))<=10"}>}Sales)

to two reference lines.

PFA an example