up vote 1 down vote favorite
share [g+] share [fb]

I have all my data grouped by year and then sorted by month (in an Excel Pivot Table):

2007                                    2008
January    February     March    ...    January    February    March

How can I group this as follow:

January         February        March
2007    2008    2007    2008    2007    2008

I've set the column labels like this but without any succes.

Columns labels

  • Month
  • Year

Then I get this:

January    February    March
2007       2007        2007
link|improve this question
75% accept rate
feedback

1 Answer

up vote 0 down vote

Don't just move the labels, move the fields. You should have you field selection area, and be able to see the list of things you're showing in the columns. Reorder them there.

link|improve this answer
Can you explain this in a bit more detail? I'm not sure if I understand it correctly. Should I reorder them in the PivotTable Field List? img441.imageshack.us/img441/9453/2601201185523.png – thomasvdb Jan 26 '11 at 7:58
At the bottom of that image, in orange. Swap them around. – Rob Farley Jan 26 '11 at 12:18
I've tried that but then I get a result as my last example (in the question). – thomasvdb Jan 27 '11 at 10:22
It sounds to me like your Month field also contains information about what year it is. – Rob Farley Jan 28 '11 at 7:32
This was indeed the problem! – thomasvdb Nov 22 '11 at 8:22
feedback

Your Answer

 
or
required, but never shown
discard

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