Need Pivot Table Help Real Quick Please

toy4x4

New Member
Joined
Jun 27, 2005
Messages
14
Ok, under the gun timeframe wise so if anyone can help with I would appreciate it. Yes, this is the first time I have done a pivot table so hopefully this will be a easy question.

I have used the wizard to create the layout.

For the row I put the following two items:

Part Number (Column A)
Part Decription (Column B)

For the Data I out the following items

Count for Part Number (Column A)(to show me how many rows have the same part number)
Sum of Part Quantity (Column C)
Sum of Total $ (Column D)

All the data shows up correctly, however it shows each of the DATA items on a seperate row. I need to change it to show the DATA in Columns.

Meaning it shows my data vertically when I want to show it horizontally.

Hope this makes sense!

Thanks in advance!
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

toy4x4

New Member
Joined
Jun 27, 2005
Messages
14
Try google next time bonehead!

"After you add the two fields to the pivot table's data area, drag the Data field button to the right, onto the cell that contains the word 'Total'."
 

Watch MrExcel Video

Forum statistics

Threads
1,114,415
Messages
5,547,808
Members
410,813
Latest member
Vhinzvirgo
Top