I have a formula that is a groupby wrapped with sort:
=SORT(GROUPBY(...),8,-1)
Since I'm sorting my totals column by descending, it's bringing the totals row to the top. Is there any way to keep it at the bottom?
I'm trying to do a groupby with the below formula:
=GROUPBY(A1:A9,HSTACK(FILTER(B1:B9,C1:C9=D1),B1:B9),SUM,1,1,3)
Column A: Region
Column B: Count
Column C: Date
D1: Date I'm filtering by
I'm trying to use groupby to have one column just from a specific date, and a second column with a total of all dates. Is there a reason that the filter does not work for looking at a specific date?