Pivot tables in Google Sheets queries rock.
They let you build an entire time series report with one formula, and have become my weapon of choice for building advanced spreadsheet templates.
For more background on the Query function, grab a copy of the Google Sheets formula cheat sheet at:
https://trello.com/c/b2q3P0E3/39-10-key-google-sheets-formulas
