Average Salary

[#1]

How do I calculate average salary for a particular position?

[chrislofthouse]

avg({< [Position]={ 'POSITION' } >} [Salary])

[sunny_talwar]

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