How to make a Pivot Table always display all the field values even when they contain no data

preview_player
Показать описание
Sometimes you just want your Pivot Table to have a fixed number of rows or columns and stop “dancing” every time you change your filter selection. Watch how to achieve that.

----------------------

---

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer



Twitter: @celia_excel

Instagram: @solveandexcel


#excel #msexcel #powerquery #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA

-------------------------

#Excel #shorts #solveandexcel #microsoft365 #toronto #torontobusiness #wit #msexcel #microsoftexcel #excelreport #excelautomation #snapreports #powerquery #canada
Рекомендации по теме
Комментарии
Автор

Hi Celia. Great tip! Thanks for sharing how to fix this issue :)) Thumbs up!!

wayneedmondson
Автор

Hi Celia. "Show items with no data" is disabled for me. What could be the issue?

AjazJamil
Автор

Just what I needed for my pivotchart too!

patrickcardon