software

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?

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 Govierquot;dicoxquot; gt; wrote in message
...
gt;I have a pivot table with 2 regions in it. Eastern region has FL, VA;
gt;Western
gt; region CA. For whatever reason, the pivot table shows both Eastern and
gt; Western region with all 3 states FL, VA and CA, with empty values for
gt; the
gt; states that do not belong to the region. How can I get rid of the
gt; states that
gt; do not belong to the region?
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:
gt; I have a pivot table with 2 regions in it. Eastern region has FL, VA; Western
gt; region CA. For whatever reason, the pivot table shows both Eastern and
gt; Western region with all 3 states FL, VA and CA, with empty values for the
gt; states that do not belong to the region. How can I get rid of the states that
gt; do not belong to the region?--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlThanks. This explains it.

quot;dicoxquot; wrote:

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