pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formatting Pivot table breaks 7
PIVOT TABLE SUM OF AVERAGES 1
How-To fill down blank spaces in outlined table? 2
Pivot Table 2
always display rows in Pivot tables (show items with no data) 1
Top 10 autoshow in PivotTables 1
Need help with complex pivot... 4
Pivot table grand total options 3

Back
Top