+ Reply to Thread
Results 1 to 3 of 3

Cannot create "Calculated Item" in Pivot Table. Option GRAYED OUT

  1. #1
    Registered User
    Join Date
    12-11-2015
    Location
    Texas
    MS-Off Ver
    MS Office 2013
    Posts
    18

    Post Cannot create "Calculated Item" in Pivot Table. Option GRAYED OUT

    I am trying to insert a calculated item on my pivot table that calculates the Profit margin. I have two columns Revenue and Expense and would like to add a third column "Profit Margin". The calculated column would look like this "Profit Margin = (Revenue-Expense)/Revenue". No matter where I click in the pivot table both the Calculated Field and Calculated Items options are grayed out within the "Fields, Items, & Sets" section.

    Here is my excel file.
    November Revenue.zip
    Last edited by tbucki1; 12-11-2015 at 08:34 PM. Reason: Added Attachment

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Cannot create "Calculated Item" in Pivot Table. Option GRAYED OUT

    A lot of people will not download from a file service. You can create a ZIP file and upload your file here.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    12-11-2015
    Location
    Texas
    MS-Off Ver
    MS Office 2013
    Posts
    18

    Re: Cannot create "Calculated Item" in Pivot Table. Option GRAYED OUT

    Thanks, I updated my post with the attachment.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. "Manual" option grayed out in Edit Links window
    By JayUSA in forum Excel General
    Replies: 4
    Last Post: 07-07-2015, 05:21 AM
  2. Replies: 2
    Last Post: 08-05-2014, 11:24 AM
  3. Pivot Table calculated field to count if issue "needs follow up"
    By xnukemx47 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-07-2014, 06:18 PM
  4. How To Add "Count" as a Column Item In Pivot Table
    By fredmeister in forum Excel General
    Replies: 5
    Last Post: 09-25-2008, 09:11 AM
  5. My &amp;quot;Print Titles&amp;quot; option is grayed out.
    By Vegas Rigger in forum Excel General
    Replies: 1
    Last Post: 04-22-2006, 11:45 PM
  6. How to "blank" pivot table calculated fields if result = 0
    By Joe in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2006, 01:45 PM
  7. Merging Excel Files - Option "grayed out"
    By Stilla in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-20-2006, 10:35 AM

Tags for this Thread

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