Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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:

SELECT 
    DATE_FORMAT(`Timestamp`, '%Y-%b'), 
    SUM(`Unit Price`*`Quantity`) 
FROM 
    TABLE1
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

1 Answer 1

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

 
discard

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.