How do I filter "Blank" cells in Pivot Table

F

Felipe Brochier

I'm trying to filter the "Blank" cells in my pivot table as a "page" filter,
but I'm not getting any success. On the contrary of showing the "blank" cells
the Pivot Table shows all the values. I've already tried to format the cells
in the source table as "number", but it didn't work. Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Pivot Table cell values 1
Filtering by group in pivot table 0
Slicers and Calculated Items in Pivot Table 2
VLOOKUP a Pivot Table Filter 0
PivotTable - Filter Row 0
Pivot table - Filter - no filter by value 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top