Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Issue
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Issue
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. Titanium wrote: 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 Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Issue
Thank you Debra. Your reply solved my problem. :)
"Debra Dalgleish" wrote: 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. Titanium wrote: 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 Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Filename reference in Spreadsheet XML issue | Excel Discussion (Misc queries) | |||
Pivot Table issue in Excel 2007 | Excel Discussion (Misc queries) | |||
Ongoing Pivot Table Issue | Excel Discussion (Misc queries) | |||
Pivot Table Memory Issue - Excel crashes | Excel Discussion (Misc queries) | |||
pivot table version issue | Excel Discussion (Misc queries) |