3 Replies Latest reply: Sep 6, 2011 3:07 AM by lindabeale RSS

    Chart: Possible for each bar's value to be dependent on the avg of its group?


      I have a chart with Name as dimension, and bottom 3 names are displayed according to value compared to total avg of all values:

      Adam ===
      Mike ====
      Lisa =======

      Every name is connected to a particular profession.

      What I really want to do is to display the bottom 3 names that has the lowest value compared to the avg of the values in its own profession (not the total as it currently is). The fact that Adam is an accountant and Mike is a programmer should not stop them from appearing in the same chart.

      Is this possible? I have been trying with set analysis for a couple of hours, but cannot get it to work. Any help is appreciated.