yogi_WorkAround For Including SubTotal Lines In Google Spreadsheet

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

lathseka said:
I really find it hard as I am new to this. You helped me to sum by items, manufacturer and buyer. To continue on that, I want to know how to sum also each item within the grouping. As you can see to begin with there is only one apple row. Next to that row should be the sum for apple. The next 3 rows are Asparagus. At the end of Asparagus, there should be sum for asparagus etc..


Is this possible with keeping the query?
-----------------------------------------------
I think what lathseka is trying to do is insert SubTotal line like in Excel. Goggle spreadsheet does not have a
feature to add the SubTotal lines ... so in the following solution one way to include the SubTotal lines with my convoluted approach presented here

yogi_Compute Total For Sales Data Grouped By Item_Manuf_Buyer

Google Spreadsheet

lathseka said:

I have a spreadsheet with Date, ID, Buyers, manufacturers, items, quantity, total. I want to sort by item, then by manufacturers, then by buyers and get sum for every item by manufacturer and buyers and insert a new sheet items, manufacturers, buyers, total and get a grand total also.

--------------------------------------------------

latseka's sales data is in the sheet named Sales, and I used the QUERY function to group the sales data by Item, Manufacturer, and Buyer and then the corresponding sum from sales data