2 Replies Latest reply: Aug 29, 2012 5:59 AM by whiteline _ RSS

    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