pie chart on 70/20/10 ratio based on sales

[Former Member]

Experts,

I have a requirement where I have to show pie chart based on sales where I need to show number of customers who contributes towards 70/20/10 % of the total sales. Pie chart Slice should be divided on 70/20/10% of the total sales but the value on each slice should show the number of customer who contributed to that sales. I guess it's similar to Pareto analysis. How do I achieve this in webi?

Thank you in advance

Dar

[Former Member · Accepted solution]

Hi,

Can you give sample input and output data?. Basically which customer has to fall under which bucket (10/20/70 etc)

[Former Member · Accepted solution]

Hi Divya,

Basically customers with highest sales to lowest should fall under 70/20/10 bucket.

for example, we have 10 customers and total sales for all the customer is £100.

if £70 worth of sales comes from 2 customers than they become part of 70%.

another 3 customers sales adds up to another £20 than they become part of 20% and remaining 5 customers sales are part of 10% bucket as their sales adds up to £10.

hope this helps.

Thank you,

Dar

[former_member199945 · Accepted solution]

Hi,

you have two create two variables

v1= percentage(custcount/customerkpi) * 100 this will give you percentage.

v2= if(v1>=0 and v1<=10) then (10) elseif(v1>10 ) and v1<20) then (20) else (70).

this will give you 10/20/70 ratio of customers.

Thanks

[Former Member · Accepted solution]

Hi,

Thanks for clarification, please try below

create variable to get the percentage

Measure per = =Percentage([Sales revenue])

Measure runningper=RunningSum([per])

Dimension bucket==(If([runningper]<=70;1;If([runningper]>70 And [runningper]<=90;2;3))) In([Customer])

CountMeasure  countofCustomer= count([Customer])

Create your pie chart with countofCustomer and bucket objects

[Former Member · Accepted solution]

Hi Seshu,

it works fine when we have a detailed level data but it doesn't work when we remove the detailed level data. How do I apply sort on the sales (Descending) while using it on formula?

thanks,

Dar

[former_member199945 · Accepted solution]

Hi Dar,

Apply sort on created variable v1.

Thanks.

[Former Member · Accepted solution]

Hi Dar,

I just published this document that will give you the solution : Measure contribution in a chart

Didier