How to Prevent Empty Cells from Displaying in a Pivot Table

One of my viewers asked me how to prevent "empty cells" from displaying in a Pivot Table. This is a common request. Frequently, when you send a Pivot Table to a client or a colleague who is unfamiliar with Pivot Tables, they will question why these "empty cells" appear.
Watch as I demonstrate how to fix this. You will also learn how to "drill down" to see the detail behind any Pivot Table Subtotal. In addition, I show you a great Keyboard Shortcut for quickly applying and clearing filters in a structured data set.
I invite you to visit my secure online shopping website - shop.thecompanyrocks.com - to see all of the video training resources that I offer.
Danny Rocks
The Company Rocks

[@DannyRocksExcels]