calculation of a sub-group on a super group

[#1]

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

[#2]

Hi Stephen,

sounds like you want to use average aggr() over the higher level dimension, would be helpful if you can upload an example application to work with

Joe

[#3]

Hi Joe,

Unfortunately can't upload, but i came right with some trial and error:

(

sum(Hold_time)/sum(Hold_Time_Occ)

)

/

(

aggr(nodistinct sum(Hold_time), TLead )

/

aggr(nodistinct sum(Hold_Time_Occ), TLead )

)

Thanks