pivot table
 

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?

pivot table
 

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.

--
Regards

Roger Govier


"dicox" wrote in message
...
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?

pivot table
 

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.

dicox wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

pivot table
 

Thanks. This explains it.

"dicox" wrote:

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?