Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
= avg(aggr(sum(Salary), Title))
Try this:
= avg(aggr(sum(Salary), Title))
avg(TOTAL <Title> Salary)
Thank you massimo it worked