+ Reply to Thread
Results 1 to 2 of 2

adding calculated PowerPivot field to Pivot Table

  1. 03-08-2017, 01:02 PM #1
    AtlanteanIdol
    AtlanteanIdol is offline
    Registered User
    Join Date
    04-16-2016
    Location
    Maine, USA
    MS-Off Ver
    2007
    Posts
    3

    adding calculated PowerPivot field to Pivot Table

    Hi,

    I'm trying to add from a PowerPivot source table a calculated column called Act Avg CPC. When I go to the field list, however, Act Avg CPC appears only in the tables list, not the calculated column list. The file is too large to upload, so I've attached a couple of screenshots. Any suggestions?
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 03-09-2017, 09:49 AM #2
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: adding calculated PowerPivot field to Pivot Table

    Hi,

    Calculated columns can't be placed into the Values area. You need a measure for that.
    Don
    Please remember to mark your thread 'Solved' when appropriate.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding a calculated field to a pivot table is not giving me the results that I think it sh
    By OodaLoop in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-18-2013, 03:50 PM
  2. Calculated Field in Pivot Table Based on One Summed Field and one Counted Field
    By ddgacic in forum Excel General
    Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  3. Need help in adding a calculated field/column in OLAP based PowerPivot table
    By DNICE1 in forum Excel General
    Replies: 0
    Last Post: 06-22-2012, 07:13 AM
  4. Adding new calculated/column field to pivot table
    By MARYAN in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-09-2010, 05:34 AM
  5. Pivot Table - Adding Average as calculated field
    By Matt1234au in forum Excel General
    Replies: 4
    Last Post: 12-22-2009, 08:50 PM
  6. Adding a percentage calculated field column in my pivot table
    By Zyphon in forum Excel General
    Replies: 3
    Last Post: 02-23-2009, 10:07 AM
  7. [SOLVED] pivot table formulas for calculated field or calculated item
    By Vicky in forum Excel General
    Replies: 3
    Last Post: 06-06-2006, 12:10 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1