Forum Discussion
Solved
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.
In general it's better to work with data model, but if with cached PivotTable calculated item could be added:
Perhaps you may share sample file?
- 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!
- yes, I can do that when the dataset is just 3 columns wide. But I have 7 more columns as in my screenshot. What I can not understand: why is adding a calculated item possible when the source is just 3 columns wide, and why is it no longer possible when I have 7 more columns. I can not attach the file here, but just try adding a new column and make a pivot with that.
