Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
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:
DIMENSIONS
Category
ProductType
EXPRESSION
=sum(Sales)
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?
Thanks
Make sure "Enable Secondary Trellis Dimension" is unchecked.
If I understand correctly you sould change the order of you dimensions and uncheck Secondary trllis dimension.