Pivot table: trying to add a calculated field, but it's greyed out

Question

Hi,

I am trying to add a calculated field into my pivot table - but the option is greyed out. 

My data is coming from a query table. While creating a pivot table i insert in a data model. 

I am showing the %row total of certain categories per week, but also want to add the total count of all categories per week. For that i am trying to add a calculated field but it's greyed out. 

Another option i tried was I dragged the same data column into the pivot table values field - but instead of just showing me the total count per week it's also showing count of each category. How can i just add the total count of categories as a second field? It's essentially the same data column as the % row total with no calculation. i attached the image - the yellow column is what i want to add to the pivot table. 

Thanks,Nana  

Answer 1

Hi,

Do not add the Data to the Data Model.  Now you should be able to write the calculated field formula.

Answer 2

Can anyone from Microsoft community help with this question? 

I have Excel 2016, and 365 ProPlus.

Answer 3

Hi Nana,

To resolve your concern, simply refer to this support article and follow the steps provided.

Let us know if you need further assistance.

Thank you.