Pivot Tables: Excel 2003 vs Excel 2007

S

Scott

I have a problem with the Excel 2007 pivot table layout that's different from
the Excel 2003 pivot table layout. Is there a way in Excel 2007 to present
the pivot table the way data was presented in Excel 2003?

Example: Let's say I have four people with the last name of "Smith."
In Excel 2003 pivot tables, I could show all four "Smiths" with the first
name and last name together on the same row.

Col A Col B
Smith Joe
Smith Bill
Smith Mike
Smith Tom


In Excel 2007, I get the last name and first name on separate rows. In
addition, Excel 2007 only shows "Smith" once and then indents all the first
names on a separate row.

Col A Col B
Smith
Bill
Mike
Tom

How can I get the first name and last name on the same row in Excel 2007
Pivot Tables?

Thanks,
Scott
 
P

PJFry

Right click on your pivot table and choose 'Field Settings'. Under the
'Layout & Print' tab there is a radio button for 'Show Item Labels In Tabular
Form'.

Give that a try.
 

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

parsing a full name out into Last, First, Middle 2
Excel 2007 Pivot Tables compatible with 2003 3
sum by rows in Pivot 1
Displaying multiple matches 7
Pivot Table Excel 2003 & Excel 2007 3
Lose formatting on pivot tables 3
Excel Pivot Table How to Sort data as Percent of Row 12
Count unique items in pivot table results 5

Top