This content has been marked as final. Show 2 replies
I'm creating a trellis chart for the first time.
I want a pie chart "multiplied" with the number of product categories I have so that's an obvious dimension. But then I want to calculate my sales on basis of Product Type (that can be either "1" or "0") and have a slice representing each Product Type.
So what I do is the following:
But, when enabling Trellis and "Second Dimension" I get this weird result:
0,1 = ProductType
00,1A,1E,etc... = Category
How do I get the result I want?