Rows disappear in pivot table

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

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?
 
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.
 
Back
Top