RE: Why cant I exclude items with no data from the Page Field?
- From: Ethoros <Ethoros@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 8 Jul 2009 05:59:02 -0700
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.
.
- Follow-Ups:
- References:
- Prev by Date: Re: Get the row count of different areas in the Excel
- Next by Date: select a single cell in excel 07, currently selecting a goup
- Previous by thread: RE: Why cant I exclude items with no data from the Page Field?
- Next by thread: RE: Why cant I exclude items with no data from the Page Field?
- Index(es):
Relevant Pages
|
