Search code examples
google-sheetsgoogle-sheets-formulagoogle-query-language

How can I extract top 5 sums?


=QUERY('BD3'!A:Q,
"SELECT L,D,I,SUM(M)
WHERE I='W34' AND M>0 AND L='Huacho' 
GROUP BY L,D,I",-1)

I need to just show the top 5 sums of column M.


Solution

  • =query('BD3'!A:Q, "SELECT L,D,I, SUM(M) WHERE I='W34' AND M>0 and L='Huacho' GROUP BY L,D,I ORDER BY SUM(M) DESC LIMIT 5",-1)