how to calculate average value?

[francis_gr]

Hi!

I have employee table with the sales per year (2011 to 2013)

I need that selecting a employee, calculate the average sales per year of all employees with the same job that the selected person .

I tried with Avg (Total ([ventas])) but doesn´t work (show the same wrong value each year)

Thanks

[Greg_Williams]

Have you tried avg(aggr(sum(sales),year))

[swuehl]

Maybe something like this:

avg({<JobField = p(), EmployeeField = >} [ventas])

in a chart with dimension Year and selecting in EmployeeField.

[francis_gr]

Thanks for your quick reply!!

I`ve tried your expresíon but it shows the same sales values that the person that i have selected, not the average values per year  of all employees with the same job

Regards

[francis_gr]

Hi!

Thanks for your reply!

Show the same sales values per year that have the selected person, so i haven´t the average per year and job of the group to which the employee selected belongs

Regards