as the auto filter when you select any item appears only the related data to
it so the range of choice will be less, i ask for an option in the pivot
table do the same to be more easy to choice from less choices don't choose
from all items in the data base ,only from the items which related to my
choose.

There's no option in the pivot table that will create dependent dropdown
lists in the page fields.

Hossam wrote:
as the auto filter when you select any item appears only the related data to
it so the range of choice will be less, i ask for an option in the pivot
table do the same to be more easy to choice from less choices don't choose
from all items in the data base ,only from the items which related to my
choose.


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