Here is a simplied version of a list that I have created a PivotTable
from:
Country,State/Prov,City,Value
USA,California,Oakland,5920
USA,California,San Diego,1294
USA,Texas,Houston,9712
USA,Texas,Dallas,3237
Canada,Alberta,Calgary,6670
Canada,Alberta,Edmonton,2810
Canada,Ontario,Toronto,4127
Canada,Ontario,Ottawa,8914
(Copy & paste into Excel, use the "Text to Columns..." command set to
delimited, with the delimiter being a comma.)
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:
(Show All)
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:
(Show All)
California
Texas
Any assistance will greatly be appreciated.
Thanks,
Dave
|
|