2 Replies Latest reply: Jul 1, 2011 1:38 PM by Razor Ramon RSS

    Relative Problem in a stacked bar chart

      Hi guys,

       

      I have a bar that has 2 dimensions. One for the month of the year and the other dimension to show a location.

       

      My aim is to show values for each area relative to each other on a monthly basis.

       

      Example:

       

      I have one simple expression which is Sum(value)

       

      Jun 2010 - I want a stacked bar chart that will show all the values relative to each other i.e 40%, 20%, 40%

      Jul 2010 - I want another stacked bar showing values relative to each other i.e 35%, 30%, 30% and so on for other months.

       

      I have the relative box ticked, but it calculating the value for every month reltaive to each other as opposed to calculating each individual month relatively.

       

      Is there a way to get around doing this and getting the relative thing to work as expected?

       

      Thank you