#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Pivottable Filter

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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,696
Default Pivottable Filter

OK, it sounds like you're going to want to have one big table to make thsi
easiest.
In the table, column C will have every single plaer for all leagues listed
Column B will list which team each player s on (so, same team will be in the
list multiple times) Column A will be the league (Lots of the same data, as
many players will belong to the same league)

Once you have this set up, highlight the table, go to:
Data-Filter-Autofilter
This will give you drop-down boxes in row 1
Hit the drop-down in league, select desired league
Now, drop-down for team will only show teams in that league
Then, drop-down for player will only show players on that team...

"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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 PivotTable Named Sets as a filter DaBus11 Excel Discussion (Misc queries) 0 July 27th 06 03:47 AM
Excel 2007 PivotTable Report Filter area not working DaBus11 Excel Discussion (Misc queries) 0 July 27th 06 03:42 AM
Print Pivottable - show all selected items in page filter Koen Excel Discussion (Misc queries) 0 June 19th 06 10:30 AM
Excel auto filter doesn't recoginize case - won't filter AA from A Mikey Excel Discussion (Misc queries) 1 September 29th 05 09:18 PM
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du TC Excel Worksheet Functions 1 May 12th 05 03:06 AM


All times are GMT +1. The time now is 09:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"