Pivot table - GetData

[Astrid]

Hi,

I am trying to extract some data from a pivot table. One of my columns is Cars and it contains race car numbers. Another Column is Driver and for each of the previous cars I have 2 to 3 drivers. To each of these cars/drivers are associated lap time data (best, mean, number of laps, etc).

An example of what I would like to do is to extract the mean lap time for the driver X from the car Y. I imagine it would be something like that :

For Each car in Pvt.PivotFields("Cars").PivotItems
For Each driver in car
....
Next
Next

but I can't manage to make it work....

any ideas on how to do it?
Cheers