I've done this before,... because I have an old pivot table/chart that shows rows with no data.
I've even tried to copy+paste new data in, and adjust the pivot table data source - but as soon as i do that, I cannot get "rows with no data" to be displayed.
I'm going into the Pivot Table Fields, and the Row field, Field Setting - Layout and Print - "show items with no data"... but doesn't seem to make a difference.
Help would be greatly appreciated! 🙏🙏🙏
Bookmarks