+ Reply to Thread
Results 1 to 2 of 2

Calculated Field in Pivot Table, won't copy to other Pivot Tables

  1. #1
    Registered User
    Join Date
    03-18-2010
    Location
    Edmonton, AB, Canada
    MS-Off Ver
    Excel 2002
    Posts
    28

    Question Calculated Field in Pivot Table, won't copy to other Pivot Tables

    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!
    Last edited by Calieth; 04-12-2010 at 01:01 PM.

  2. #2
    Registered User
    Join Date
    03-18-2010
    Location
    Edmonton, AB, Canada
    MS-Off Ver
    Excel 2002
    Posts
    28

    Re: Calculated Field in Pivot Table, won't copy to other Pivot Tables

    I was approaching it wrong. The field must be inserted using the Wizard.

    Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1