2 Replies Latest reply on Aug 15, 2018 11:35 PM by Mahfooj Khan

Hi everyone. I have an issue:

Let's say we have  sales, manufacturer, products and sales date together in a table.

Now we are able to find sales per manufacturer of a certain year or for several years.

How I'm able to entlist products for each manufaturer which contribute nearly 80% of sales per manufacturer?

I attached a screenshot: In this case you can see that ProdA,B and E are 80% of total sales for the manufacturer "Good Things".

Now we only want to see the yellow marked lines.

Is there an easy way if you have a bunch of manufacturer and products?

Thanks for any hints.

• ###### 1. Re: Enlist all products, 80% of total sales per manufaturer

Hi,

There is a miss of logic in your statement.

Example:

a - 5

b - 1

c - 1

d - 1

e - 1

f - 1

So how do you choose groups to determine 80%?

However in someway in is still possible.

Calculation:

IF RUNNING_SUM(SUM([Sales]) / TOTAL(SUM([Sales]))) <= 0.8

THEN 'Show'

END

You can sort your dimension according to metric in descending order.

Example is in the attachment.

Trust this helps.

D

• ###### 2. Re: Enlist all products, 80% of total sales per manufaturer

Hi,

This is called Pareto chart

• Drag Product field in columns shelf

• Drag sales measure in rows shelf

• Sort the products in descending order based on sales measure

• Now apply quick table calculations

Primary calculation type: Running total

Secondary calculation type: Percent of total

Once done then create a calculated field to highlight the products met the 80% of total sales target or you can use constant reference line like this

80% of Total Sales:

RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales]))>0.8

Finally you'll get something like this.

Let us know if this help. Workbook v10.5 attached for reference.

Mahfooj

1 of 1 people found this helpful