Rows disappear in pivot table



I have a pivot table with states as the page filter. I have getpivotdata
calculations outside the pivot table, which I originally calculated from the
pivot table with all states selected. The problem is that when I select only
one state, not all the rows from the all state table have data, and so the
table contracts. Now several of the getpivotdata formulas don't reference
anything, and I get error messages. Is there any way to keep all the rows in
the pivot table, even when there are no data for that row for a given filter?



Debra Dalgleish

In the pivot table, double-click on a field button, to open the
PivotTable Field dialog box.
Add a check mark to Show Items With No Data, then click OK.

Do this for any fields in which you want to keep all items visible.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question