When a filter is applied to a Pivot Table, you may see rows or columns disappear.
This is because pivot tables, by default, display only items that contain data.
In the example shown, a filter has been applied to exclude the East region.
you’re able to use the same approach, with a few extra steps,described here.
