Avg - issue

[#1]

Hi All,

I need to show avg salary value inplace of 0, for example

I have title X itz avg salary is 1500, 1500 value should display in first row as well for the Name Kim, but

it is showing once.

Title	Name	Salary	Avg Salary
X	Kim	2000	0
X	Jane	1000	1500
Y	Kelly	4000	0
Y	Sally	3000	3500
Z	Kiran	5000	5000

Expected

Title	Name	Salary	Avg Salary
X	Kim	2000	1500
X	Jane	1000	1500
Y	Kelly	4000	3500
Y	Sally	3000	3500
Z	Kiran	5000	5000

Thanks

[oknotsen · Accepted solution]

Try this:

= avg(aggr(sum(Salary), Title))

[maxgro]

avg(TOTAL <Title> Salary)

[#4]

Thank you massimo it worked