Forum Discussion
GROUPBY aggregating more than one column of data
In the early versions of Excel beta, we were able to create a formula like this: =GROUPBY(Table[Code], Table[[Duration]:[Expense]], SUM, 3) and this worked just fine. But now, the...
I found a solution, easy as: just use HSTACK to pass multiple arrays to the GROUPBY first argument. An example that works:
=GROUPBY(HSTACK(
tblBillingData[Account Number],
tblBillingData[Item],
tblBillingData[Remark]),
tblBillingData[GST Exclusive],SUM,0,0,1,
)
What I haven't figured out yet is how to return sum(amount) and sum(units).