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?