Group by using an expression

[meg007]

How can I do the following using an expression and not data load editor

get max invoices per month per supplier

E.g. select supplier,month,max(transaction) as invoice

from <table>
group by 1,2

how can I build this using an expression/formula?

[GaryGiles · Accepted solution]

It depends on where/how you want to use the expression.  The aggr() function is a good place to start.

=aggr(max(transaction), supplier, month)