how to include a average column in simple chart

[francis_gr]

Hi!

I need to add a new field in "average" chart (see the attached file) to calculate the avearge sales (sale_1, sale_2, sale_3) per year and job. I know that in excel it can be done with SUMIFS and COUNTIFS functions

I need this new field to calculate the percentage sales difference from the average sales

Regards

[francis_gr]

Hi Jonathan!

I've attached the original excel fille.

Anyway, the expresion Gerardo has done AGGR(NODISTINCT Avg(Sales_1),Job,Year)  works

Thanks for your help and time

Regards