Pivot Tables & Excel 2007

C

Cassie

Just switched from Excel 2003 to 2007 and just getting to grips with
reworking my pivots from the previous version.
In 2003 Rows in Pivot should be listed sideby side, if you had a number of
Row items they would be listed in Col B, C, D etc until the numerical data.
In 2007 rows seem to be nested is there away of unnesting and showing
multiple text rows sideby side
Thanks
Cassie
 
A

AFSSkier

Cassie,

Try playing with the Pivot Design Layout in 2007, to get the result you're
looking for. In this case, PivotTable Tools, Design, Report Layout, Tabular
Form
 

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

Pivot Tables in 2007 1
2007 pivot tables in 2003 6
dynamic data range in pivot tables excel 2007 1
Building pivot tables in Excel 2007 based on existing pivot tables? 4
Hide empty rows in pivot table Excel 2003 2
2007 Pivot to Access 1
Pivot table wizards 2
2007 Pivot tables 1

Top