2007 Pivot tables

A

Alan M

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?
 
I

Ian Grega

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question on the occupied field of the pivot table in excel spreadsheet 0
dynamic data range in pivot tables excel 2007 1
Pivot Tables & Excel 2007 1
Grouping Dates in Excel 2007 Pivot Tables 1
Rows to columns in a table or pivot table 4
Pivot Tables in 2007 1
Pivot Tables from more than one tabs 2
How to set default calculation method in pivot tables? 2

Top