March 13, 2022

Struggle to make a calculated field appear in a PivotTable

I had a calculated field in a table that I was using to populate a PivotTable. All the other fields appeared in the field list, but no matter what I did, the calculated field wouldn’t show up. Refreshing, closing and opening the file didn’t work, exiting and re-launching Excel didn’t work. What finally worked: closing Excel and leaving the computer alone for a day. The following day, the field appeared in the list and I was able to use it in the PivotTable. Weird.

Categories

Share:

Related Posts

Excel formula: convert Roman numerals to regular Arabic numbers

Last year, I did a TikTok video blog post about Excel’s =ROMAN function (watch it here). It will convert any regular Arabic number to Roman.

Microsoft removed the =COPILOT function from Excel

Microsoft will remove the experimental =COPILOT function from the Excel beta. They said they want functions to be more dependable and precise.

Now certified in AI Ethics

Just earned my third AI certification: AI+ Ethics, from AI Certs. Now offering training in ethics issues, including transparency, accountability, privacy, mitigating bias and compliance

AI chatbots helped researchers plot deadly attacks

From The Guardian: “Users posing as would-be school shooters find AI tools offer detailed advice on how to perpetrate violence. Tests of 10 chatbots carried

Earned another AI certification

I just earned the AI+ Executive certification from AI Certs. This is to assist and train companies in developing AI strategies, governance and risk management,