Class PivotLayout (Excel VBA)

The class PivotLayout represents the placement of fields in a PivotChart report.

Parent

Returns the parent object for the specified object. Read-only.

PivotTable

Returns a PivotTable object that represents the PivotTable report associated with the PivotChart report.

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable 
pvtTable.PivotFields("Country").CurrentPage = "Canada"