ExcelBanter - Pivot table show pages but omit those without data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot table show pages but omit those without data (https://www.excelbanter.com/excel-discussion-misc-queries/31007-pivot-table-show-pages-but-omit-those-without-data.html)

Angus

Pivot table show pages but omit those without data

When I use "show pages" at pivot table, it shows all pages by the selected
page field with or without data. How to show page only with those with data?

Can I use VBA for this?

All times are GMT +1. The time now is 09:39 AM.