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

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.

  • 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

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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