google-sheets - 查询功能按问题排序 Google 表格

Question

我已经准备好查询的第一部分，但我想先订购最新日期。你能帮忙吗！

=QUERY(Sheet3!A:I, "
SELECT D, -1 * SUM(I)
  GROUP BY D
  LABEL -1 * SUM(I) 'Balance Diario'
  FORMAT D         'yyyy-MMM-dd',
        -1 * SUM(I) '$#,##0.00'
")

标签： google-sheetsgoogle-sheets-macros

Answer 1

这是你要找的吗？

=QUERY(Sheet3!A:I, "
SELECT D, -1 * SUM(I)
  GROUP BY D
  ORDER BY D DESC
  LABEL -1 * SUM(I) 'Balance Diario'
  FORMAT D          'yyyy-MMM-dd',
        -1 * SUM(I) '$#,##0.00'
")

放更多ORDER BY D ASC或DESC

DESC是颠倒顺序