Group by using an expression

meg007 — Fri, 11 Jun 2021 14:13:54 GMT

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?

Re: Group by using an expression

GaryGiles — Fri, 11 Jun 2021 14:24:47 GMT

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)