3 Replies Latest reply: Jul 16, 2013 2:01 PM by Mubbasher Khaliq RSS

    Lowest avg benchmark , results effected by dimension filtering

      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.