Forum Discussion
Excel Pivot table showing only part of one row
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!
Your Row Label (Rpt_ID 736) appears multiple times in your source data. For the first 3 columns in the Pivot Table, all those duplicate rows happen to have the exact same value (e.g., "R2.1 Rpt D"). But for the remaining columns, the duplicate rows have different values from each other. Because Excel doesn't know which one to show, it shows you a blank (instead of picking one arbitrarily).