2 Replies Latest reply: Jan 28, 2015 11:23 PM by Stephen Naude RSS

    calculation of a sub-group on a super group

    Stephen Naude

      Hi all,

       

      I have a straight table where i am grouping on a employee level, what i want to do now is measure an average on the employee level against the average on a team leader level (the empoyee's team leader)

       

      So if Agent X is a member of team Y, i want Agent X's Average measured against Team Y's Average (Agent X is a member of team Y)

       

      i want this calculation to happen regardless of whether anything has been selected or not

       

      thanks