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

[#1]

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.

[#2 · Accepted solution]

did you the AGGR function as

AGGR( avg(salary) , profession) => it means the average salary for each profession.

Give feed back and if you can post your application.

JJ

[#3]

Thanks alot. The following code shows the people with lowest avarage compared to their professions in percentage;

[salary]

/ AGGR( avg([salary]) , profession)

[#4]

Thank you - I know that this has been answered but it is very helpful