
1. Re: Enlist all products, 80% of total sales per manufaturer
David Maning Aug 15, 2018 1:16 PM (in response to Patrick Weber)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

4Patrick.twbx 2.4 MB


2. Re: Enlist all products, 80% of total sales per manufaturer
Mahfooj Khan Aug 15, 2018 11:35 PM (in response to Patrick Weber)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

Pareto_v10.5.twbx 139.6 KB
