Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
share|improve this question

1 Answer 1

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.

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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