2007 Pivot Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John13 - 15 Feb 2008 13:29 GMT

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

Reply to this Message

Debra Dalgleish - 15 Feb 2008 13:42 GMT

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

> 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
[quoted text clipped - 25 lines]
>
> John

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

John13 - 15 Feb 2008 15:19 GMT

> Select a cell in the pivot table.
> On the Ribbon, click the Design tab
[quoted text clipped - 36 lines]
>
> - 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.

Reply to this Message

Tyro - 15 Feb 2008 23:13 GMT

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

Tyro

On Feb 15, 8:42 am, Debra Dalgleish <d...@contexturesXSPAM.com> wrote:

> Select a cell in the pivot table.
> On the Ribbon, click the Design tab
[quoted text clipped - 37 lines]
>
> - Show quoted text -

Reply to this Message

Debra Dalgleish - 15 Feb 2008 23:50 GMT

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.

>>Select a cell in the pivot table.
>>On the Ribbon, click the Design tab
[quoted text clipped - 45 lines]
> Can I get everything to one row like Excel 2003? Again thank you for
> your help. I really appreciate it.

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

Herbert Seidenberg - 15 Feb 2008 23:52 GMT

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

Reply to this Message