Forum Discussion
rylach
Helper II
Helper IISelect max value for a group based on another column
Hi, Lookin as the following table: TableA: id value key 1 a 1 1 b 2 1 c 3 2 a 4 2 d 5 2 f 6 how can I write a formula for a column in another table (re...
Looking for examples of MAXX+RELATEDTABLE I found the solution, didn't know LOOKUPVALUE accepts more than one key/value pairs:
Greg_Deckler
Community Champion
Community Championrylach - Use MAXX along with RELATEDTABLE.
rylachHelper II
Helper IILooking for examples of MAXX+RELATEDTABLE I found the solution, didn't know LOOKUPVALUE accepts more than one key/value pairs: