Aggr function based on specified field AND dimension

[Anonymous]

Hi QlikComm,

I am trying to set a calculation which will tell me the value of the highest performing sales person based on their sales figures. I use the firstsortedvalue function with aggr, however, I want it to be calculated on the based off whatever dimension I have but of course with the salesperson as primary aggr dimension.

e.g, only have this as Expression  firstsortedvalue(Salesperson, -aggr(sum(sales),Salesperson))

then have MONTH as dimension

I know we can add it to the expression, but the point is to use this calc in a few more objects with different dimensions.

Many thanks

[sunny_talwar]

Are you looking for this??