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[…]