Google Spreadsheet Post #1475
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-06-2014
question by Ken Parker 23 (http://productforums.google.com/forum/?zx=ckhas5yzitpf#!category-topic/docs/spreadsheets/YlqUoaoYjbw)
query function and dates
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-06-2014
question by Ken Parker 23 (http://productforums.google.com/forum/?zx=ckhas5yzitpf#!category-topic/docs/spreadsheets/YlqUoaoYjbw)
query function and dates
I have a simple sheet that lists transactions
The transaction sheet is as follows
Cell A: Month (January, February, etc.)
Cell G is category (dining, mortgage, utilities, etc.)
Cell E is amount spent
On my summary sheet here is my query formula
=query(Transactions!A:G;" select G, sum(E) group by G pivot A")
My problem is when I pivot the A col (months), it orders alphabetically. I would like my column headers to go in order of month. Any suggestions?
Thanks in advance.
------------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment