Missing values from a pivot table field

K

Kelli

I am creating a pivot table from an access database containing 896426
records. The issue I am running into is that on one of the fields the pivot
table is only pulling in one of two values, but the access table does contain
the second value. When I click on the arrow associated with that field it
does not contain the second value either. Is there somewhere else in the
settings this value could have been lost?
 
J

Jim Thomlinson

Perhaps try
Drag the field off the table
Refresh the table
Drag the field back on.

With pivot tables you need to let us know which XL version you have. pivot
tables changed in XL2002 and 2007 is a bit different also.
 

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 Table cell values 1
Dealing with a Pivot Table (when I don't want to) 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Create a chart from a table in word thats dynamic 0
pivot table help 0
Pivot Table Calculated Field 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Pivot Table Mapping 1

Top