AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
4.2K members online now
4.2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Group date field by month

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

I have a Google Sheet with some transaction information that looks like this

 

| Location | Amount | Date       |
|----------|--------|------------|
| Chicago  | $10.00 | 01/01/2017 |
| New York | $11.50 | 01/01/2017 |
| Chicago  | $12.00 | 01/01/2017 |
| LA       | $9.50  | 01/02/2017 |

 

I'd like to produce a report that groups and sums these transactions by month and Location:

 

| Location | January 2017 | February 2017 |
|----------|--------------|---------------|
| Chicago  | $10,000      | $11,500       |
| New York | $25,000      | $23,460       |
| LA       | $34,000      | $11,500       |

 

Is this possible?