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