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?