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?

Rows disappear in pivot table
 

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.


Craig wrote:
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
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com