Avg of total sales if. chart

[Anonymous]

Hi

I'm working on an app but have unfortunatly got stuck in one place.

What I'm trying to achive is that Person7 in attached example gets the avarege amout of sales as the other persons.

Íf a person belongs in Department4, he should recieve the avarege amout of sales as the remaining persons. Would this be possible?

best regard.

/Björn

[sunny_talwar · Accepted solution]

May be like this

If(Department = 4, Avg(TOTAL {<Department -= {'4'}>}Sales), Sales)

[Anonymous]

Thanks. That works great if the Sales column is found in the data file.

In my case the Sales collumn is an expression and "Sales" is the Label of the expression. For some reason I can't get it to work when using the Label.

[sunny_talwar]

What is the expression?