Saturday, November 23, 2013

yogi_Cross Tabulate Sum Of Expenses by category and Year

                                          Google Spreadsheet   Post  #1429
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov 23, 2013
question by wem3rd (http://productforums.google.com/forum/?zx=6r9xv8nc97g1#!mydiscussions/docs/C9vsIXg-N-0)
Does Google Sheets have a function equivalent to the Cross Tab query in MS Access?
Does Google Sheets have a function equivalent to the Cross Tab query in MS Access that will produce a table where the row headings are listed categories of sales and columns are years?  Each cell is a sum of sales.

An example of the SQL for this in ACCES is:

TRANSFORM Sum([q By Town].Sold) AS SumOfSold
SELECT [q By Town].Town
FROM [q By Town]
GROUP BY [q By Town].Town
PIVOT [q By Town].Year;

Thank you

wem3rd

---
https://docs.google.com/spreadsheet/ccc?key=0Al0I31hHV207dEVydnJTVkJIdTVfdFpCaXVBQlowdUE&usp=drive_web#gid=0
-------------------------------------------------------------------------------------------