incorrect Avg roll up - Qlik Community

rmuhammad · ‎2017-09-26

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 · ‎2017-09-26

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

sunny_talwar · ‎2017-09-26

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

Anonymous · ‎2017-09-26

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