Here we can clearly see the highest value among the four values , and also the measure here is same i.e, profit , so its pretty easy , but what about the below one , where we have multiple measures , and from there we need to have the max/min value ?
Also , the indexing function does not work here .
Looking forward to the solution .
Thanks and Regards,
It would help to have your sheet.
My guess would be that you have to specify by which direction you would like to calculate your aggregation.