Forum Discussion
Excel Pivot table showing only part of one row
Hello,
I have an Excel pivot table that literally has one row that shows data for the 1st 3 columns and then no data for the remainder of the columns in the pivot table. All other rows in the pivot table show data for every field in the pivot table (as long as there is data in the underlying data source). The data source for the row in question is fully populated and contains no trailing spaces or other oddities that I can see. What could be causing this and how can I fix it so the data shows properly in my pivot table for this one row? (Some cell info. partially blanked out intentionally)
If your PivotTable rows are built from the first few fields, Excel may group these records together. Fields farther right then become ambiguous and may display blank.
Check…
- Double-click the problem row in the PivotTable (Rpt_ID 736).
- Excel should create a new sheet showing the underlying records.
- Look for duplicate source records with differing values in the columns that are blank in the PivotTable.
I hope this helps.
2 Replies
If your PivotTable rows are built from the first few fields, Excel may group these records together. Fields farther right then become ambiguous and may display blank.
Check…
- Double-click the problem row in the PivotTable (Rpt_ID 736).
- Excel should create a new sheet showing the underlying records.
- Look for duplicate source records with differing values in the columns that are blank in the PivotTable.
I hope this helps.
Thank you for the response - it eventually got me there and is greatly appreciated! When I double-clicked on one of the populated cells in the row, the data 'disappeared', but when I double-clicked on one of the non-populated cells, the data 're-appeared'. I can't say I completely understand why, but it's good!
