Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / June 2007

Tip: Looking for answers? Try searching our database.

Pivot Table Issue

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Titanium - 17 Jun 2007 16:55 GMT
Any help with the following problem would be most appreciated:

When I Lay out the pivot table, I put:

"TRAILER #" in the row field, and it works fine.
"# of turns" in the Colum field, however When I drag the "# of turns" in
order to display the options "1 - 2 - 3 - 4 - 5", the options are displayed
as headers but the message "Drop data items here" displays.

If I drag the "# of turns" to the left, I will get "average of # of turns"
but, all the categories show up ("1 - 2 - 3 -4 -5") in one colum next to the
colum of "Trailer #".  I won't get the display by days as headers that I want.

Thanks in advance for any help you can provide.
Debra Dalgleish - 17 Jun 2007 19:17 GMT
Add one copy of # of turns in the column area, and another copy in the
Data area. Then it will appear as headers, and and data.

> Any help with the following problem would be most appreciated:
>
[quoted text clipped - 10 lines]
>
> Thanks in advance for any help you can provide.

Signature

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

Titanium - 17 Jun 2007 20:51 GMT
Thank you Debra. Your reply solved my problem. :)

> Add one copy of # of turns in the column area, and another copy in the
> Data area. Then it will appear as headers, and and data.
[quoted text clipped - 13 lines]
> >
> > Thanks in advance for any help you can provide.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.