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.