2007 Pivot Table

[John13]

Being new to 2007, I am having trouble with Pivot Tables. I have four
columns of data, Part Number, Part Decsription, Item Class and Shipped
Quantity. When I go into pivot table I can't get the pivot table to
have Part Number in one column and Part Description in the next column
like Excel 2003 would do, they are in the same column in every other
row.

Part # Desc Class Quantity
123 Part A 50 45
124 Part B 50 63
125 Part C 50 29
126 Part D 50 54
127 Part E 50 87
128 Part F 60 69
129 Part G 60 59
130 Part H 70 21
131 Part I 70 36
132 Part J 70 47
123 Part A 50 45
124 Part B 50 63
125 Part C 50 29
126 Part D 50 54
128 Part F 60 69
129 Part G 60 59
130 Part H 70 21

What am I doing wrong please? I appreciate any help here. Thank you

John

 

[Debra Dalgleish]

Select a cell in the pivot table.
On the Ribbon, click the Design tab
In the Layout group, click Report Layout, and then click Show in Outline
Form or Show in Tabular Form

 

[John13]

Select a cell in the pivot table.
On the Ribbon, click the Design tab
In the Layout group, click Report Layout, and then click Show in Outline
Form or Show in Tabular Form









--
Debra Dalgleish
Contextureshttp://www.contextures.com/tiptech.html- Hide quoted text -

- Show quoted text -

Thank you Debra for your quick response. I couldn't see a Design Tab,
no matter what I clicked on (and not sure what the ribbon is). If I
click Part Descriotion I can get Field Settings and a Layout & Print
tab and click off the same column check for compact form, but I still
have the part number on one row and the Part Desc on one row below but
in column B and the Qty is on the same row, but in it's own column.
Can I get everything to one row like Excel 2003? Again thank you for
your help. I really appreciate it.

 

[Tyro]

You have to create the pivot table. Then you'll see the design tab

Tyro

Select a cell in the pivot table.
On the Ribbon, click the Design tab
In the Layout group, click Report Layout, and then click Show in Outline
Form or Show in Tabular Form









--
Debra Dalgleish
Contextureshttp://www.contextures.com/tiptech.html- Hide quoted text -

- Show quoted text -

Thank you Debra for your quick response. I couldn't see a Design Tab,
no matter what I clicked on (and not sure what the ribbon is). If I
click Part Descriotion I can get Field Settings and a Layout & Print
tab and click off the same column check for compact form, but I still
have the part number on one row and the Part Desc on one row below but
in column B and the Qty is on the same row, but in it's own column.
Can I get everything to one row like Excel 2003? Again thank you for
your help. I really appreciate it.

 

[Debra Dalgleish]

The Ribbon is at the top of the Excel window, where you should see the
tab names, e.g. Window, Insert, Page Layout, Formulas, etc.
Sometimes, additional tabs are visible. For example if you select a cell
inside a pivot table, you should see two new tabs -- Options and Design.
Above those tabs is the heading, PivotTable Tools.

It sounds like you right-clicked on a cell in the pivot table.
In the Field Settings dialog box, select 'Show item labels in tabular
form', and the first part desc will be on the same row as the part number.

That setting is the same as selecting 'Show in Tabular Form' on the Ribbon.

 

[Herbert Seidenberg]

Maybe a picture will help:
http://www.savefile.com/files/1382995