8 Replies Latest reply: Mar 13, 2014 1:08 PM by Burkhard Veidl RSS

    Grouped bar, 2 dim, values as 100% of 1 of the dim

    Michiel van de Goor

      I need to have a stacked bar where I have:

      Year

      Dim2

      Sum(measure)

       

      I want to show the Sum(measure) for Dim2 as 100% of Year total.

       

      stackedbar.jpg

       

      each bar should be 100% for each corresponding year.

       

      I cannot get this to work.

      If I add aggr I only get the total for 1 of the Dim2, not for each Dim2.

       

      Thanks for the help