Hi Deepak,

Thank you for your quick reply.

I am sorry, I could not tell whether this is different from what I had in the second worksheet "Order Summary Stacked Bar Chart" in my original file.  If you go over to that tab, you can see that it doesn't work.

Joanne

I am sorry, Deepak.  Could you explain what you did different?  From the screenshot, our solutions are the same.   I really appreciate your help.

I am unable to open your workbook due to my older version.  My organization upgrade together to ensure consistency.

Joanne

I am attaching the screenshot of my original worksheet, it shows that my solution doesn't work.  I can't tell what Deepak did differently.

Thank you, Deepak!  I will give you a million "likes" for this answer!  Thank you so much for the explanation.

Then the question to Tableau: from where I can see that our two design are different?  We obviously get different result by going through different process.  However, if I look at the worksheet, I really haven't found the difference.

I think what makes the result procedure-dependent is the way the "Cumulative Percent of Total" is calculated".  I will try to fix that later.  Thanks again, Deepak.