Excel 2007 : Rearranging Pivot Tables

[Miguel Martins]

Hello everybody, I'm new around here. I hope you can help me.

In Excel 2003, Pivot tables, were arranged in Row Labels, Column labels, data and Report filter, as in Excel 2007.

However, in Excel 2003, after creating the Pivot Table, I could drag and drop "Data fiields" to the left, and would rearrange the table as if that data field was a Row Label (this could be useful for Pivot Tables with more than one "Data field").

Just to make more clear what I mean, here's an example:

\1

Now, with Excel 2007, I can no longer do that.

Anyone knows how to do this in Excel 2007?

[Claymation]

I am not sure if you have tried this option yet, but right click in the pivot table and select the PivotTable Options selection. Then click the Display tab and check the "Classic PivotTable Layout" box. I think that will do the trick for you.

Hope that helps.