Pivot Table Data field
 

I have an exsisting pivot table that i would like to be able to pull
data from a certain intersection point.

I.e
pivot table
Accrual Paid
Month
Jan 10000 500
Feb 0 200
Mar 10 100

Can someone show me vba code that would get the feb accrual amount?

Is it something like pivottable.PivotFields.PivotItem(<The intersection
of Feb, and Accrual??).value?

thank you

Ps. I tried searching, but could not find anything that I could get to
work.

Pivot Table Data field
 

Look in Excel Help at GETPIVOTDATA

--
Regards,
Tom Ogilvy



"Dan McCollick" wrote:

I have an exsisting pivot table that i would like to be able to pull
data from a certain intersection point.

I.e
pivot table
Accrual Paid
Month
Jan 10000 500
Feb 0 200
Mar 10 100

Can someone show me vba code that would get the feb accrual amount?

Is it something like pivottable.PivotFields.PivotItem(<The intersection
of Feb, and Accrual??).value?

thank you

Ps. I tried searching, but could not find anything that I could get to
work.

Pivot Table Data field
 

Thanks (again) Tom.