| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
relation between fields in PivotTable
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 ! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivottable Sum of fields. | Excel Discussion (Misc queries) | |||
| PivotTable - Clear all data fields | Excel Programming | |||
| pivottable calculated fields | Excel Discussion (Misc queries) | |||
| PivotTable-Fields Page | Excel Programming | |||
| pivottable page fields | Excel Programming | |||
Threaded Mode
