So here's what I did, not sure if it's providing the correct result -
1. Went into the table calculations and edited them via the following:
a. % of Total - Compute Using, Advanced, make sure that you bring Department over into Detail.
b. Same with Sum of Profit, make sure that all the compute using have department included.
2. Switched the Chart Type to Bar, it seemed to work better.
a. Bring department to size at this point, otherwise you won't see the colors for department.
There's some variance as far as where the line end falls.
3. You can also do a line but, you have to have department brought to size while it's still on the Bar mark, otherwise the size doesn't make itself available.
I've included both. You'd have to see if this works with your own data.
Pareto (1).twbx 991.2 KB
Both the bar and line charts are essentially showing the same curve. To add more detail (I tried to keep my initial question as simple as possible), here is what the curve should look like for each of the departments individually:
The three curves are fairly unique. Another way to view the results I am looking for is by creating a simple bar chart. Using a rank calculation I am able to get the customers sorted in the order I am looking for, but I am unable to translate that to the Pareto chart.
The issue lies in the sorting. Customer Name on the level of detail is sorted by SUM(Profit), but it's sorting by total SUM(Profit) across all three departments, so customers are being sorted like so, opposed to the above image (with the correct sorting I'm looking for).
Attached is the updated workbook.
Pareto (1).twbx 1.0 MB