Forum Discussion
Excel Pivot Table shows all records but one row is displaying blanks for some columns
Hello, My Excel pivot table returns all rows that should be returned according to filters applied directly to column filters in the pivot table itself, or via some Slicers that I've created off of t...
OK - solved it (using the term 'solved' very loosely)... It was a Display setting on the Pivot Table. I didn't realize that the 'Show Expand/Collapse buttons' option had been activated. Thus, my Pivot table was showing the correct records, but whatever column had been collapsed, all the columns to the right would then become 'invisible'. I was clearly not paying attention to the Expand/Collapse buttons. This is the Setting that (in my opinion) should remain unchecked to avoid Users accidentally 'hiding' data and not knowing how to un-hide it:
Learn from my pain. 😆