EDIT: I did not see the other posts before I posted this...
Just a tweak to xk9128's formula to force the sorting:
=SORT(LET(x,Table1[Supplier],y,Table1[Spend],z,UNIQUE(x),CHOOSE({1,2},z,SUMIFS(y,x,z))),2,-1)
EDIT: I did not see the other posts before I posted this...
Just a tweak to xk9128's formula to force the sorting:
=SORT(LET(x,Table1[Supplier],y,Table1[Spend],z,UNIQUE(x),CHOOSE({1,2},z,SUMIFS(y,x,z))),2,-1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks