software

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:
gt; as the auto filter when you select any item appears only the related data to
gt; it so the range of choice will be less, i ask for an option in the pivot
gt; table do the same to be more easy to choice from less choices don't choose
gt; from all items in the data base ,only from the items which related to my
gt; choose.--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html