Data Studio
6.8K members online now
6.8K 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?