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
