Calculating average

[#1]

hey everyone.

So i am creating a report that needs to calculate the average per department.

My data is as followed:

Name	Department	Calls
Mike	A	17
Jason	A	12
Jan	A	67
Wesley	B	34
Diana	B	28
Laura	B	95
Betty	C	19
Michael	C	12
Anna	C	27
Average		34.56
Department	Calls
A	96
B	157
C	58
Average	103.67

Now i dont want to use straight tables or pivot tables, for this specific report i am using text objects for better visualization.

The formula in the text object is:

=Num(Sum({<Week={$(vCurrentWeek)}>}distinct tAgentCalls),'#,##0.00')

tAgentCalls being the field in which i have the data of the amount of calls obviously.

Now if i would do an average on this formula it would calculate the average of all employees in that selection.

Which would result in the average as seen above 34.56.

While i need it to calculate the average of the departments they are in.

Now on this specific data i have 3 people on each department, but as you can imagine this varies.

Can anybody help me with this.

[#2]

Hey Oleg,

Sorry for the confusion, i indeed meant i only needed a calculation on a department level instead of on all departments.

My apologies.

Thank you for your time.