In a pivot table lets say I have one page field "Country" and another page
field "City".
If I select England from "Country" I still get all the cities in the page
field "City" regardless if the city is in England or not. I just want the
English cities to select from.
I don't want to put either page fields into the row or column fields as it
would mess up my pivot chart.
Is there anyway this issue could be solved or is there a VBA workaround.
They have the option to exclude items with no data in the other fields, why
not the page fields?

Hi,
in the country column beside the city column , you need to repeat the
country i.e.

london England
london England
london England

"Ethoros" wrote:

In a pivot table lets say I have one page field "Country" and another page
field "City".
If I select England from "Country" I still get all the cities in the page
field "City" regardless if the city is in England or not. I just want the
English cities to select from.
I don't want to put either page fields into the row or column fields as it
would mess up my pivot chart.
Is there anyway this issue could be solved or is there a VBA workaround.
They have the option to exclude items with no data in the other fields, why
not the page fields?

Still get the same problem
For example the if the table is like so:

City Country people year
london England 1000000 2007
london England 1000001 2008
london England 1000002 2009
Madrid Spain 20000 2007
Madrid Spain 20001 2008
Madrid Spain 20002 2009


and the pivot table is like

Country (All)
City (All)

Sum of people
year Total
2007 1020000
2008 1020002
2009 1020004
Grand Total 8160056


When I select England I still get Madrid in the City Page Field even though
Madrid is not in England.
I also dont want to put the city in the column or row field because it would
mess the chart up, but I want users to be able to select the from relevant
cities.

Hi,
I copy your information and is working for me , just a question when you go
to country did you check where it says select Multiple items, and then
uncheck Spain

"Ethoros" wrote:

Still get the same problem
For example the if the table is like so:

City Country people year
london England 1000000 2007
london England 1000001 2008
london England 1000002 2009
Madrid Spain 20000 2007
Madrid Spain 20001 2008
Madrid Spain 20002 2009


and the pivot table is like

Country (All)
City (All)

Sum of people
year Total
2007 1020000
2008 1020002
2009 1020004
Grand Total 8160056


When I select England I still get Madrid in the City Page Field even though
Madrid is not in England.
I also dont want to put the city in the column or row field because it would
mess the chart up, but I want users to be able to select the from relevant
cities.

I have only England selected in the Country page field but Madrid keeps
showing in the City Page Field. Have you done the same layout as below? I'm
also using Excel 2003 if that makes any difference.

"Eduardo" wrote:

Hi,
I copy your information and is working for me , just a question when you go
to country did you check where it says select Multiple items, and then
uncheck Spain

"Ethoros" wrote:

Still get the same problem
For example the if the table is like so:

City Country people year
london England 1000000 2007
london England 1000001 2008
london England 1000002 2009
Madrid Spain 20000 2007
Madrid Spain 20001 2008
Madrid Spain 20002 2009


and the pivot table is like

Country (All)
City (All)

Sum of people
year Total
2007 1020000
2008 1020002
2009 1020004
Grand Total 8160056


When I select England I still get Madrid in the City Page Field even though
Madrid is not in England.
I also dont want to put the city in the column or row field because it would
mess the chart up, but I want users to be able to select the from relevant
cities.

Hi,
Sorry I have 2007 , it shouldn't but I cannot test it,

"Ethoros" wrote:

I have only England selected in the Country page field but Madrid keeps
showing in the City Page Field. Have you done the same layout as below? I'm
also using Excel 2003 if that makes any difference.

"Eduardo" wrote:

Hi,
I copy your information and is working for me , just a question when you go
to country did you check where it says select Multiple items, and then
uncheck Spain

"Ethoros" wrote:

Still get the same problem
For example the if the table is like so:

City Country people year
london England 1000000 2007
london England 1000001 2008
london England 1000002 2009
Madrid Spain 20000 2007
Madrid Spain 20001 2008
Madrid Spain 20002 2009


and the pivot table is like

Country (All)
City (All)

Sum of people
year Total
2007 1020000
2008 1020002
2009 1020004
Grand Total 8160056


When I select England I still get Madrid in the City Page Field even though
Madrid is not in England.
I also dont want to put the city in the column or row field because it would
mess the chart up, but I want users to be able to select the from relevant
cities.