This video looks at how to create a Google Sheets Query where the results include both the Detail Level Records but also Total Amounts in a Field by a particular grouping. This is done by using the SUMIF Function within the QUERY Function.
Learn more about Google Sheets Functions with this Book at Amazon.
https://amzn.to/3HkHcGa
Buy the complete Google Workspace User Guide at Amazon:
https://amzn.to/3Hr9dLW
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links
#GoogleSheetsQueryDetailAndTotalsInResults
#GoogleSheetsQueryReturnDetailAndTotals