In Excel 2003 you could have more than one set of row data, aligned
horisontally next to each other, in Excel 2007 when you add more than one set
of row data it nests the data in a sub menu style rather than allowing it to
be placed alongside and displaying data in the same row.

Does anyone know how I can make a pivot table display in row data alongside
rather than nested?

Alan,

Not sure if this will help, but have you tried "Pivot Table Options" -
"Display" - and then check the "Classic Pivot Table Layout" box.

This gives you the same layout that people were used to in 2003 and may fix
your problem.

Ian Grega

"Alan M" wrote:

In Excel 2003 you could have more than one set of row data, aligned
horisontally next to each other, in Excel 2007 when you add more than one set
of row data it nests the data in a sub menu style rather than allowing it to
be placed alongside and displaying data in the same row.

Does anyone know how I can make a pivot table display in row data alongside
rather than nested?