5 Replies Latest reply: Jul 26, 2012 1:17 PM by Mayil Vahanan Ramasamy RSS

    Percentage calculation in chart

      Hello, consider a column chart with the following:

       

      Series: a, b, c

      X-axis: X, Y, Z

       

      |

        |

      |

      |

      |_a b c__a b c__a b c__

             X          Y        Z

       

      Looking at the following points on x-axis:

                 X:                                 Y:

      a =      5                                   8

      b =      2                                   1

      c =      7                                   3

      (total = 14                                 12)

       

      What I would like is the following values in chart:

       

                 X:                                 Y:

      a =      5/14=36%                      8/12=67%

      b =      2/14=14%                      1/12=8%

      c =      7/14=50%                      3/12=25%

       

       

        |

        |

        |

        |

        |_36 14 50__67 8 25__........

                X              Y

       

      The numeric values is from count(value), so im not sure what the rest of the division should be.

      Something like count(value) / [count(value) for all series on that one point on x-axis]

       

      Thank you!