Wednesday, August 9, 2017

yogi_Using Query Function To Add A Subtotal Line For Each Order Number And Grand Total At The End

Google Spreadsheet   Post  #2221

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug-09-2017
question by Peter @ Kwik Kopy :
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/dJCTOLxcVyo;context-place=mydiscussions
Sheets Query add subtotals
Using a query in sheet

Is there a way to have the query interject a line with a subtotal

data example

Orange 5
Orange 6
Apple 10
Apple 6

Query result

Orange 5
Orange 6
Subtotal Orange 11

Apple 10
Apple 6
Subtotal Apple 16

Grand Total 27

thanks if anyone can help