Forum Discussion
Excel Groupby on table with Lambda
Hi, In the attached document I would like to groupby on the column "type" and then sum the values of the column "waarde" but before doing so multiply it by a certain chance (column "perc"). Howev...
Try multiplying waarde by perc directly in the values argument of GROUPBY:
=GROUPBY(Table1[type],Table1[waarde]*Table1[perc],SUM)
I was not aware of the values argument having this flexibility, but this would definitely be the most simple solution. Thanks for your quick advice 🙏
