如何向 Google 表格中查询的一列添加小计并将其偏移到附近的单元格？

=ARRAYFORMULA({QUERY(A1:B, "where A >= date '"&TEXT(A1, "yyyy-MM-dd")&"' 
                              and A <= date '"&TEXT(A4, "yyyy-MM-dd")&"'"),
 {SPLIT(TRANSPOSE(SPLIT(REPT("♥ ♦ ♦", 
  COUNTA(FILTER(A1:A, A1:A>=A1,A1:A<=A4))-1),"♥")),"♦"); 
  "Total Sum:", SUM(QUERY(A1:B, "select B where A >= date '"&TEXT(A1, "yyyy-MM-dd")&"' 
                                            and A <= date '"&TEXT(A4, "yyyy-MM-dd")&"'"))}})

=ARRAYFORMULA({QUERY({VALUE(SUBSTITUTE('All payments'!D2:D, "₹",)), 'All payments'!A2:M, 
 DATEVALUE('All payments'!E2:E), 'All payments'!A2:A, 'All payments'!Y2:Y}, 
 "select ' ', Col2, SUM(Col1), Col17, Col13, Col14, Col3, Col5, Col16 
  where Col15 >= "&DATEVALUE(F1)&" 
    and Col15 <= "&DATEVALUE(F2)&" 
  group by Col2, Col17, Col13, Col14, Col3, Col5, Col16 label SUM(Col1)'', ' '''", 0);
 QUERY(QUERY(QUERY('All payments'!A2:M, R1), Q1, 0), "select sum(Col2) label sum(Col2)''"),
 "","","","","","","",""})