Only show cells with no data

Hi,

In a pivot table, I am seeking a solution to only show cells that contain no data, and basically hide the other cells that do contain data.

For example, I have a pivot table that can display the count of 'Company A' in Australia, China and India, and where it is not such as Indonesia, Japan and Malaysia, the cells are blank. Now this is correct, however, I just want the pivot table to show the cells where there is no data (in Indonesia, Japan and Malaysia) and hide the others where there is data (Australia, China and India).

Is this possible?

Hi,

I can see this works, but when i chose the company from a slicer I need it to auto update the pivot table and not select blanks every time from another country slicer to then update the pivot table to hide the other cells that do contain values.

Hope this makes sense!