Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a Google Form. Upon submit following fields are populated:

  1. Timestamp
  2. Product Description
  3. Unit Price
  4. Quanitity

I have generated a pivot table from this data, in a Google Spreadsheet. The first column is a timestamp and the second column is the sum of Unit Price. All is grouped by the timestamp.

I don't want it. I want to show the year-month at column 1 and the total costs on that month. It should be group by that month.

In SQL I would run this query:

    DATE_FORMAT(`Timestamp`, '%Y-%b'), 
    SUM(`Unit Price`*`Quantity`) 
GROUP BY DATE_FORMAT(`Timestamp`, '%Y-%b')
share|improve this question
Can you share a doc with us? – Jacob Jan Tuinstra May 5 '13 at 21:01

You can use =text(number,format) to add a column to your original data set.

You can then use the pivot table to group them by year-month or you can use =sumif(range,criteria,sum_range) to calculate the sum based on the data in the new year-month column.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.