Inside Microsoft Excel

Find out why your PivotTable’s page fields don’t filter correctly

Inside Microsoft Excel

by Kara Hiltz

We recently came across a similar problem, and it stumped us at first. But, if your page field filter shows zero values instead of hiding irrelevant rows, you can point the finger at calculated items.

When you include a calculated item in your PivotTable, you can use formulas to view your data. Calculated items come in handy when you don’t want to include those formulas in your source data, but only in your[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)