incorrect Avg roll up

[rmuhammad]

I have a pivot country/ category by service years with avg hourly $rate .... total line not averaging correctly. what could be the problem any suggestions?

[Anil_Babu_Samineni]

Instead 9.34 it should show 11.08 $. Isn't it?? Will you able to provide exxpression you used..

[sunny_talwar]

May be try with Avg(Aggr(Expression, Dimension/s))

[Anonymous]

Avg(Total Aggr(Sum([Service Years]),country_category))