Filtering in a PivotTable

D

Dave

Here is a simplied version of a list that I have created a PivotTable
from:

Country State/Prov City Value

USA California Oakland 3245
USA California San Diego 6532
USA Texas Houston 7543
USA Texas Dallas 2113
Canada Alberta Calgary 1222
Canada Alberta Edmonton 8432
Canada Ontario Toronto 4921
Canada Ontario Ottawa 1007

I created a PivotTable where Country is the first row field, State/
Prov is the second row field, and City is the third row field. When I
click the drop-down arrow for the Country field, it displays the
following values with checkboxes preceding them:

(Show All)
USA
Canada

If I choose USA, then click the drop-down arrow for the State/Prov
field, it displays the following values with checkboxes preceding
them:

California
Texas
Alberta
Ontario

Is there any way to set up the PivotTable so that if I choose USA from
the Country field, then click the drop-down arrow for the State field,
only states in USA display, as follows:

California
Texas

Any assistance will greatly be appreciated.

Thanks,

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top