4 Replies Latest reply: Jun 26, 2017 5:17 PM by Sunny Talwar RSS

    Stacked bar chart that adds 100% from multiple columns

    Carlos Daniel

      Given the following data, how can i produce a graph that shows:

       

       

      CATMONTHF1F2F3
      111
      116
      114
      112
      213
      214
      215
      22 2
      22 3
      32 5
      32 6
      32 7
      32 8
      32 9
      33 1
      43 2
      43 3
      43 4
      43 5
      53 6

       

       

      The Column CAT as a dimension

      The Column Month as a sub-dimension

       

      The Sum of F1+F2+F3 as a stacked bar chart, that always has a total of 100%