"Calculated fields" function greyed out
infomag
Posted messages
195
Status
Membre
-
Zoll -
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!!
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 réponses
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!!!!
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!!!!
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.
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.
If anyone has a tip, I'm all ears!!
Thanks!
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.