Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I calculate average salary for a particular position?
avg({< [Position]={ 'POSITION' } >} [Salary])
In a straight table you can have Position as dimension and Avg(Salary) as an expression.
Within a text box, if you want a average salary for a particular position, you can do something like this:
Avg({<Position = {'CEO'}>} Salary)
HTH
Best,
S