Monday, January 6, 2014

yogi_Using QUERY Pivot By Month Arrange Pivot Results By Month Name Rather Than By Month Number

                                          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
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