2 Replies Latest reply: Sep 25, 2018 1:43 PM by Dilip Ranjith RSS

    Expression in bar charts with multidimension

    Tiziano Gelso

      Hi,

      I have a table like this:

      YearKeyFieldTypeValue
      2008001ObjectA2
      2008001ObjectB3
      2008001PlayerA18
      2008001PlayerB3
      2008001BookA7
      2008001BookB12
      ...............

       

      and I want to creare a "Horizontal Stacked Bar Chart"  with dimension:

      Stack = Key

      Bar = Field

      and measures:

      (Sum(Value)/sum(total(Value)))

      Measures need to show the percent.

      It show in this way:

      Screenshot (51).png

      but I need to show something like this:

       

      Screenshot (52).png

      I think that I need to modify the Measure expression to calculate the percent in a way that is right to take the full value, but I don't know how.

       

      Thanks to all