I am trying to find out the value of "Make" field which has highest "Invoice" value for each "Type".
I have achieved it in the backend, but to make it more dynamic based on front end selection, I need to calculate it at UI level.
Example of Source Data: (NOTE: Full excel file for the same is attached)
Target Output for above partial data:
|Type||MAX(Invoice)||Max Price maker|
Thanks in advance for the help.
Apart from this, is there any way we can achieve the same using Nested aggregation with MAX() and AGGR().
You solution is quite simple and awesome. I am just trying to expand my knowledge on use of AGGR() function too.
Thanks again for the help and look forward to your reply.