A calculated field can only refer to fields in its own pivot table. It
can't refer to other pivot tables.
carolini wrote:
Can a formula be done in one Pivot Table using a field from another pivot
Table?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html