Pivot Table field to show all (select all)

[sdoppke]

Hi everyonw,ive been searching the threads for awhile to figure out how to make my pivot table completely expans (or show all fields). I see alot on how to filter the fileds down, but nothing to select all.

I little clearer explanation: I would like to "select all" (Show all) in the following field (distric)

Set pvtTable = Worksheets("Variance Report").PivotTables("PivotTable3")
Set pvtField = pvtTable.PivotFields("District")

thanks evyone in advance

sd