2

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')
1
  • Can you share a doc with us?
    – Jacob Jan
    Commented May 5, 2013 at 21:01

1 Answer 1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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