Help Needed: Multiple Curves in Pareto Chart

Sometimes you want to do something in Tableau that makes sense in your head and should be easy enough to accomplish. But then... it doesn't work. I've spent the last week on this issue. I've roped in my wife, a BI Developer. I've gone to sleep thinking about this problem and woke up thinking about it. Yes, I'm saying I've had nightmares about data. Here are the details of my dilemma:

I am very interested in using a Pareto chart to visualize some of my data. For the purposes of my question, I am going to use the Sample - Superstore dataset that comes with Tableau.

To begin, I created a Pareto chart showing the number of customers that contribute to profit:


But what I really want to do is compare multiple curves for Product Category, let's say. When I add Product Category to the color shelf, I get jagged curves. I believe this is due to the sorting of Customer Name. In the screenshot above, Customer Name is sorted by SUM(Profit) and it works great when there are no other dimensions. In the screenshot below, Customer Name is being sorted the same way, but it's not sorting Customer Name by SUM(Profit) for each Product Category. Customer Name is being sorted by SUM(Profit) across all Product Categories.


You can find a packaged workbook on Tableau's Forum: http://community.tableausoftware.com/thread/155394

Thank you for your help!

Asian Style Salad Recipe

A photo posted by Brandi Beals (@all4beals5) on

Asian Style Salad

For the Dressing (modified from A Family Feast blog):
  • 1/4 cup rice vinegar
  • 1/4 cup soy sauce
  • 2 tablespoons honey
  • 2 tablespoons sesame seed oil
  • 1/2 tablespoon granulated sugar
  • 1 tablespoon toasted sesame seeds
  • 1 tablespoon lemon juice
* I bet for a little extra protein you could add some peanut butter to the dressing.

For the Salad (modified from myfitnesspal blog):
  • 4 cups red cabbage, thinly sliced
  • 4 cups broccoli florets
  • 4 large carrots, peeled and grated or sliced into matchsticks
  • 1-2 medium red bell pepper, sliced into matchsticks
  • 1 cup peanuts
  • 1 tablespoon sesame seeds
*  You could add kale or some sort of meat to this dish as well.

Directions:
  1. Whisk together all ingredients for the dressing (or put everything in a small blender and blend) and set aside until ready to use. (The sesame seeds will float to the top of the dressing so shake before each use.)
  2. Add the cabbage, broccoli, bell pepper, and carrots to a large serving bowl.
  3. Pour desired amount of dressing over the salad and toss until everything is coated.
  4. Add the sesame seeds and peanuts and toss again.


Hand Soap Comparison

The wife wanted to know which site was the cheapest place to get hand soap from. My dorkiness kicked in and this is what happened:



I like to use software products that most people have already... Word, PowerPoint, Excel, etc. I didn't put much time into making this pretty - quick and dirty.