| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot field dropping one item
Hi, this is driving me nuts. I have a pivot table based on an external query
in an mdb file. One of the fields in the qry is called Segment and contains 9 possible text values. When it comes into Excel, and is put as a page item, it shows only eight, dropping one of the possible items, even though that item does actually have data. Does anyone have any idea why????? Any thoughts would be appreciated. -- Sharon |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot field dropping one item
Does the item appear if you move the field to the row or column area?
Sharon wrote: Hi, this is driving me nuts. I have a pivot table based on an external query in an mdb file. One of the fields in the qry is called Segment and contains 9 possible text values. When it comes into Excel, and is put as a page item, it shows only eight, dropping one of the possible items, even though that item does actually have data. Does anyone have any idea why????? Any thoughts would be appreciated. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table is dropping text from a long field | Excel Discussion (Misc queries) | |||
| Conditional Formatting of Pivot Table Field | Excel Discussion (Misc queries) | |||
| Pivot Table Calculated field item | Excel Discussion (Misc queries) | |||
| Delete item from Pivot Table field? | Charts and Charting in Excel | |||
| Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
Hybrid Mode
