yogi_Using Query Function To Add A Subtotal Line For Each Item

Google Spreadsheet   Post  #2217

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug-07-2017

question by Peter @ Kwik Kopy :

https://productforums.google.com/forum/#!topic/docs/dJCTOLxcVyo;context-place=forum/docs
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