View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Pivottable Filter

No, the page fields in a pivot table aren't dependent. Selecting an item
from one page field won't affect any of the other page fields.

You could add the fields to the row area, and if you deselect a league,
only its teams would be visible in the next column.

excelrook wrote:
Is there any way to have a pivotable filter orders? For example: sports
leagues is one filter, the teams in the different leagues is another filter,
and the players on the teams is another filter. Is there a way to select a
certain league in the first filter, and only show the teams in that league in
the teams filter? Furthermore, only show the players on a selected team in
the players filter?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html