This content has been marked as final. Show 2 replies
I have a table of time measurements where the dimensions are component and user groups:
Per each of these there is a min_time and max_time values.
I want to display the min and max of these values per each user group (they are 1, 5, 10, 50, 100...).
The proble is that I need MAX(min_time) and MAX(max_time), but the latter should correspond to the component with the max(min_time).
The table below is what I naturally get:
I need the formula to display 17.491 since this is the component with the max(min_time) value.
Any ideas on how to accomplish this?
Thanks in advance.