Forum Discussion

Brass Contributor

Nov 05, 2021

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 ...

sample - pivot item issue - success.xlsx31 KB

sample - pivot item issue - 0.xlsx27 KB

excel

SergeiBaklan
Nov 06, 2021
szilvia_vf

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.
sample - pivot item issue - 0 (1).xlsx27 KB

SergeiBaklan

Diamond Contributor

Nov 06, 2021

szilvia_vf

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?

add calculated item.xlsx15 KB

szilvia_vf

Brass Contributor

Nov 06, 2021

I uploaded two files and a bit of explanation at the end of my original post, please check for clarification.

SergeiBaklan
Diamond Contributor
Nov 06, 2021
szilvia_vf

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.
sample - pivot item issue - 0 (1).xlsx27 KB
- szilvia_vf
  Brass Contributor
  Nov 06, 2021
  you're the best! Thank you so much!
  - SergeiBaklan
    Diamond Contributor
    Nov 06, 2021
    szilvia_vf , you are welcome