Hello, I am looking to add to this formula.
In the example, I added a unique customer number, that I want to return also in the Let/Filter formula.
I appreciate any help.![]()
=LET(b,FILTER(Table1,Table1[DATE]>TODAY()-30),u,UNIQUE(INDEX(b,,1)),s,SORT(HSTACK(u,MAP(u,LAMBDA(x,SUM(N(INDEX(b,,1)=x)))),MAP(u,LAMBDA(x,SUM(N(INDEX(b,,1)=x)*INDEX(b,,4))))),2,-1),s)
Thank you,
Nick
Bookmarks