Forum Discussion
pivot table - unable to add calculated item - Excel says it's grouped but why?
Hi all, I want to understand why Excel consideres a pivot table grouped and how this could be resolved? So I have a table with 10 columns, and I want to make a pivot table where only 3 cols are ...
In on of the tables you have field Year
which most probably appeared when you added Date (jelentkezés dátuma) to the PivotTable. You may add date again (Month and/or Year will appear), ungroup it and after that remove from Rows. Year shall disappear. After that you may add desired calculated item.
I uploaded two files and a bit of explanation at the end of my original post, please check for clarification.
In on of the tables you have field Year
which most probably appeared when you added Date (jelentkezés dátuma) to the PivotTable. You may add date again (Month and/or Year will appear), ungroup it and after that remove from Rows. Year shall disappear. After that you may add desired calculated item.
- you're the best! Thank you so much!
szilvia_vf , you are welcome
