Forum Discussion
Solved
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...
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.
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!