View original (French)

"Calculated fields" function greyed out

infomag Posted messages 195 Status Member -  
 Zoll -
Hello everyone,

Well, after extensive research, I have the impression that I am the only one experiencing this problem, or almost...
I created a pivot table and I would like to add a column that recalculates properly when my data source changes... so I thought about using a "calculated field," but unfortunately, this function is greyed out...
Perhaps there's an add-in missing for my Excel, but I can't find out which one... I'm using the 2013 version, and it's the same with the small business version or the professional version...

Thanks in advance!!

2 answers

  1.
    infomag Posted messages 195 Status Member 10
     
    Thank you for your response!

    Here is the file:
    https://www.cjoint.com/c/GDmlpyO7KTL

    I would like to add a column "full-time equivalent" by dividing column D by one of the two yellow ones depending on the row label value...

    Thank you a thousand times!!!!
    3
    1. infomag Posted messages 195 Status Member 10
       
      Well, I think I've found it: if we check "add to data model" when creating the table (which allows for the distinct count), the calculated fields option is no longer available... Arghhhhhh
      If anyone has a tip, I'm all ears!!
      Thanks!
      0
    2. Sebev Posted messages 1 Status Member
       
      Have you found a way to solve your problem?
      I have the same issue. I would like to add an empty column but I can't find the option to add a calculated field.
      0
    3. Zoll
       
      Redo your pivot table!! That's the solution I found.
      0
  2. DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   717
     
    Hello,

    Do you have at least 2 columns of numbers?

    Please attach a test file (with ALL the explanations and the desired results) or better yet, if possible, the actual file, as it's more convenient for the participants.

    1) Go to https://www.cjoint.com/
    2) Click on [Browse] to select your file
    3) Scroll down to the bottom of the page to click on [Create Cjoint link]
    4) After a few seconds, a blue underlined link will appear; select it and click "Copy"
    5) Go back to the discussion, and in your reply message, do: "Paste".

    Regards.
    0