Filtering through Page fields in Excel

[arunjhalani]

Is it Possible to to have Sequential filters while using Fields in Page Field of a pivot Table.
e.g

I Have columns of Customer Group,Product Group, Customer Name,Product name, Despatch Quantities.

Now I want to Display through Pivot chart the Various Combinations :
There are 10 Customer Groups & I have 5 Customer Name in a group (ie 50 Customer) Similarly for Product Name & Group.

Now while displaying , If I choose Particular Customer Group, the Corresponding Customer name Should show in the Page Field(Customer name) . IS it Workable ?

I think I ve Stated my Exact requirement.

 

[Andrew Poulsom]

Pivot Table Page Fields are not designed to behave like AutoFilter dropdowns, if that's what you mean.

 

[arunjhalani]

Pivot Table Page Fields are not designed to behave like AutoFilter dropdowns, if that's what you mean.

Can We design that to get the maximum of Pivot ??

 

[Andrew Poulsom]

I don't know a way.