I'm trying to return the dimension value that AGGR() has created and aggregated over. I've used the following formula in an expression, with Month as my dimension in my chart, to find the max values every month:
=MAX(AGGR(SUM({<[Not_My_Dummy] = {'0'} , My_dummy = {'1'}, ResolutionDate -= {'Null'}>} ABC_Resolved_Dummy), ResolvedBy, Month))
However, I would like to return the Dimension Values that correspond to these numbers, is this possible? For example, in August, the Max count is 232, corresponding to John Doe. I wish to represent John Doe on this chart for August so it's easy to I.D. who is performing well...