1 Reply Latest reply on Aug 7, 2012 11:27 AM by Tracy Rodgers

    Creating stacked bar chart with measures

      Hi all,

       

      I have 3 measures that I would like to combine to create a stacked bar chart and then from there a Percent of Total.

       

      Is this possible? Whenever I add all 3 measures to the rows column and select show me > stacked bar chart, it displays them in separate graphs.

       

      For example:

       

      Lap 1 - 30.2 seconds (Measure 1)

      Lap 2 - 12.4 seconds (Measure 2)

      Lap 3 - 26.4 seconds (Measure 3)

       

      Percent of Total for Lap 1 = Lap 1 / (Lap 1 + Lap 2 + Lap 3)

       

      I've seen this done using dimensions, but not with measures.