Hi,

I've got a pivot with a possibility for various row/column fields. I want
to click on one of the data values in the data section and it will return me
the value of a row field, only if that particular row field is being used.

My thought would be to use that automatic GetPivotData formula because it
lists out all relevant fields. However, how can I extract what I want from
this formula or is there another easier way?

Example

Country Prov City Population Highest Temp
Canada BC Van 1,222,222 35
Canda BC Surrey 400,000 45

When I click on 45, I want to know what City it belongs to.

Is this possible?

Thanks,
Carmen