Excel – Pivot table cannot create calculated item

microsoft excelpivot table

I've encountered a problem with pivot tables in Excel.

I want to create calculated item, but it does not allow me, as it says This Pivot report field is grouped

But it's not grouped in any way.

I even tried to copy my data to new workbook. It contains only one names in rows, months in columns and one single value as value. I've never grouped anything, but it is still consider this table as grouped.

Does anyone know, why that could be? Thanks!

Best Answer

Try this:

On the actual pivot table, right click the columns months, select Ungroup

enter image description here

Let me know if this does not work and I will remove this answer.

Related Question