pivot table

D

dicox

I have a pivot table with 2 regions in it. Eastern region has FL, VA; Western
region CA. For whatever reason, the pivot table shows both Eastern and
Western region with all 3 states FL, VA and CA, with empty values for the
states that do not belong to the region. How can I get rid of the states that
do not belong to the region?
 
R

Roger Govier

Hi
Try dragging Region out of the PT, then Refreshing the table with the
red exclamation, then drag Region back to the PT again.
If the PT had values against the States originally (whilst they were
wrongly allocated to the wrong region, even though there is no data
there now, the PT does retain unused values.
 
D

Debra Dalgleish

If you create calculated items in the pivot table, you'll see all the
states, even if they don't have data in a region.

Remove the calculated item, and the empty values will disappear.
 
Top