Pivot field dropping one item

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot ... Drag Multiple Fields from Field List? 1
Don't want the "All" option in the Drop Page Field of a pivot tabl 1
how to drag multiple items to pivot table report at once 0
XL2007 - Pivot Table Limitations 2
Pivot Table dropping items from page item list 4
Problem with Calculated item in Pivot Table 1
pivot table - drop down filter box has 10% of items out of order 2
Data Field Items deleted when unchecked in Pivot table 1

Back
Top