Lowest avg benchmark , results effected by dimension filtering

[#1]

Hi everyone ,

Here is my expression which gives me lowest sale profit avg which is used as benchmark lower bound

Min(

Aggr(

Avg({$<Saleman=>}TOTAL <Saleman> sale_profit)

,Saleman)

)

But the problem is when I filter Saleman dimension by selecting some Salesman this expression does not ignore that selection and calculate lowest avg of selected salesman, Whereas ideally it should be fixed throughout the selection as it is assumed to be used as benchmark.Any help is really appreciated.

[Gysbert_Wassenaar · Accepted solution]

Try:

Min({$<Saleman=>}

Aggr(

Avg({$<Saleman=>}TOTAL <Saleman> sale_profit)

,Saleman)

)

[swuehl]

Try

Min({<Saleman=>}

Aggr(

Avg({$<Saleman=>}TOTAL <Saleman> sale_profit)

,Saleman)

)

[#4]

Thanks a lot...You really have great expertise...