Hello everybody !

I have a question - how can I get "related value" from pivot table ?
(e.g. Customer name in column / pivotfield "Customer" for Work_ID in
column / pivotfield "Work_ID"

For Each pvtItm In
Sheets("PT_WorkConsumption").PivotTables("Works"). PivotFields("Work_ID").PivotItems

' get value in related column "Customer"

Next pvtItm

Thanks in advance to all !