If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Missing values from a pivot table field
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? |
#2
|
|||
|
|||
Missing values from a pivot table field
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. -- HTH... Jim Thomlinson "Kelli" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|