u have to use getPivotdata function

or you can just select the cell where you want to place the value
type =
and then select the field you want in your pivot table.. hit Enter

It should have generated the getpivotdata command for you...


hope that helps