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. |
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) |