3 Replies Latest reply: May 15, 2012 8:31 PM by Phil Bishop RSS

    Chart stacked with 2 dimensions

    Guy Vermeiren

      Hello,

       

      Here's is adifficult one:

       

      I have a pivot table where I have 2 dimensions (Category and Month) an 3 expressions. Data is in enclosure.

      Now I want to create a graph where I have Month on the axis an the values for Category stacked (total = 100%).

       

      Any idea anyone ??

      Thanks in advance

       

      Kind regards,

      Guy

        • Chart stacked with 2 dimensions
          Phil Bishop

          Create a stacked bar chart using Month and Category as dimensions. For each expression, be sure to include TOTAL <Month> in the aggregation. This will produce 100% for each month. I do not believe you will be able to cluster the 3 expressions with a stacked dimension, but possibly with a 3-D bar(?) At a minimum you can cycle the expressions.
          -Phil

            • Re: Chart stacked with 2 dimensions
              Guy Vermeiren

              Thanks for the idea Phil.

               

              I already did this but I'm getting the wrong result (see enclosure).

              My graph is cumulating the percentages by Category / Month (= sum of the different percentages for the differnet figures). In my result that I added you can see what I mean.

              Category and Figures (Revenue/Budget) have to switch from axis, but the question is how ??

               

              Kind regards,

              Guy

                • Re: Chart stacked with 2 dimensions
                  Phil Bishop

                  Right, you have to either disable 2 of the expressions or group all expressions together. Since you are displaying 3 expressions, the total for each month will add to 300%. When you display one expression at a time, the total will be 100%.
                  As an alternative, I created an example for you (attached) using trellis. I don't think you can stack it, but it will provide the correct results within each month.
                  -Phil