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

    Stacked bar chart

      Hi,

      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,