Getting one field value from pivot table

[reddyshekar]

Hi,

I am using excel 2003.I have one pivot table.I am showing some field values in excel sheet from pivot table.Now i want to extract one field value from my pivot table and keep in one column just beside my current values in sheet.
Please help me on this.I tried with some functions but could not succeeded.

Thanks

Shekar

[Claymation]

Welcome to the board.

Have you tried the GETPIVOTDATA formula? That seems like it would do the trick for what you are looking for.