AFAIK you can't do this. A pivot is justy a view of a data from a database
requested using some SQL. You need to access that data directly.
Alternatively, if you have the items in columns in the PT, then try the
VLOOKUP() function.

"Vlado Sveda" wrote:

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 !