Pivot Table Missing Values

[daithiboy]

Hi Folks,

I have a table with 10+ columns and about 2000 rows of data.

When I break this down with a pivot table by "Personnel Number" one number remains blank in the pivot table. All of the other info relating to the personnel number is listed as normal in the pivot table. the number in question is "6031557" and is stored as a number.


The curious thing is, if I add an extra digit to the number on my data source, hey presto it sorts itself out in the pivot table.

Any thoughts?

 

[WaterGypsy]

Do you have a filter on the column?

 

[WaterGypsy]

or conditional formatting to hide the value?

 

[daithiboy]

or conditional formatting to hide the value?

Hi WaterGypsy,

No filters on the source data table. There is conditional formatting on the source data but not effecting that row.

My head is well and truly scratched!

 

[WaterGypsy]

I'm bamboozled too ..... the range of the table must be right 'cos simply changing the value shows it.

Afraid I'm not clear if your problem is that the data for that personel id doesn't appear at all or if the pivot table row appears but the cell for the personel id is blank.

 

[daithiboy]

I'm bamboozled too ..... the range of the table must be right 'cos simply changing the value shows it.

Afraid I'm not clear if your problem is that the data for that personel id doesn't appear at all or if the pivot table row appears but the cell for the personel id is blank.

The pivot table row appears but the cell for the personnel id is blank. But if I change the ID it shows.

Very strange. I've even typed in the row data into a new row and deleted the old one. Same problem.

 

[WaterGypsy]

Sorry I've been away for a few days ..... looking at it logically then the reason the cell appears to be empty is purely down to the content ... to me that implies there is a conditional formatting to make the text invisible when that value appears ... have you tried to highlight the column it should appear in to see if it is hidden?

 

[RoryA]

Perhaps you accidentally overwrote the value in the pivot table with say a space. Have you tried dragging the field off the pivot table, refreshing the pivot, then putting the field back? That should reset it.