EXCEL PRO TIP: PivotTable Errors & Empty Rows

[@wayneedmondson1065]

Hi Chris.. great tip. Right clicking often comes to the rescue :-)) On whether to show blanks or not.. typically.. if I format to not show, then the manger says "where are all the categories for each country?" and if I format to show, then the manger says "why are you showing all the Genre's with no data?". So.. can't win.. haha.. but nice to know you can show it either way. Also, I like to show blanks and errors with a dash "-" just to make it easier for the eye to align values across fields horizontally.. just my preference.. works well in many situations. Thanks again for sharing all your great videos and tips.. very helpful and appreciated! Thumbs up!!

[@ExcelMaven]

Ha, I've been there!