3 Replies Latest reply: Jul 26, 2012 9:07 AM by gabrielh RSS

    How to: percentage of whole (x-axis) in chart

      Hello,

       

      Considering a columnchart with {A,B,C} as series and {1, 2 ,3, 4} as x-axis.

       

      The measure I'd like would be an count(Y) but as an percentage of [the total count(Y) from whole x-axis for that specific serie]

       

      In other words, if we're looking at an example of A:

       

      X-axis-member:     Count(Y)-measure:          The %-measure I'd like:

      1                          25                                  25/52 => 48%

      2                          5                                    5/52 => 10%

      3                          12                                  12/52 => 23%

      4                          10                                  10/52 => 19%

                               _____

        total count(Y) =   52

       

      The results would be different for each serie, as we calculate percentages not against the overall total but for the total of that one serie.

       

      I belive i need a set expression but cant figure out how to do it.

       

      Thank you