Hi there!
I've created a document with many pivot tables. After creation of the entire document, a new addition was requested, which called for a calculated field.
I went to the first Pivot Table, created the calculated field and inserted it. Worked great.
But now I need the same field in every pivot table in the workbook.
This calculated field shows up in the field list, but will not allow me to drag it into new pivot tables. Error message is "The field you are moving can not be placed in that Pivot Table Area". But it is a calculation/field created for that area. (And worked perfectly in the first pivot table)
I've tried going to the pivot table toolbar, finding the custom calculation and hitting ok. The pivot table refreshes, but does not add the calculation.
I've even tried recreating the custom calculation in each successive pivot table, but of course it will not let you name them the same. So even this time-waster will not work.
Am I approaching this wrong? Any suggestions?
Thanks!
Bookmarks