Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with trellis pie charts

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:

trellis.png

0,1 = ProductType

00,1A,1E,etc... = Category

How do I get the result I want?

Thanks

2 Replies
kji
Employee
Employee

Make sure "Enable Secondary Trellis Dimension" is unchecked.

whiteline
Master II
Master II

If I understand correctly you sould change the order of you dimensions and uncheck Secondary trllis dimension.