5 Replies Latest reply: Nov 8, 2013 1:47 PM by Kelly Schwaller RSS

    Stacked bar chart


      I have the tables attached ( where for clarity I have deleted the dimension rows as they are not useful for the chart I want to create).

      The first table has the total, while the second is filtered by the value Sex='F' and the third one by the value Sex='M'



      From that table/data I want to create a chart with stacked bars as the one I have attached.

      However I cannot create that, as the dimensions I want to put on x axis are, in reality, expressions:


      Exp1 =Sum ({<[Soc]={'001'}>}[cost 1])

      Exp2 =sum({<[Class]={'C'}>} [sales 1])


      Is there a way to achive that?


      many thanks in advance,