Log In
Register
Home
Active Member
September 7, 2020
Offline
in pivot table when I calculated item this massage appear
"the item cannot be added or modified there may not be enough memory, the maximum number of items allowed in a field may have been reached, or if a visual basic macro is performing the operation, the macro may be incorrect.
simplify the pivottable report or check the macro for errors, and then try the operation again."
I attached the massage
please I need Solve
See Answer
Trusted Members
December 20, 2019
Offline
Nothing attached
Active Member
September 7, 2020
Offline
sorry I attached the massage again
July 16, 2010
Offline
Hi Diaa,
I don't know of a fix for this issue and a Google search didn't have any conclusive fixes, so I'd be inclined to find a workaround like using Power Query to calculate the item before loading the data to Excel and creating your PivotTable. I can't really help you more without a sample Excel file containing your data and desired result.
Mynda
Active Member
September 7, 2020
Offline
Hi Mynda
i attached the Excel file containing the data and I hope to find the solution
Diaa
July 16, 2010
Offline
Hi Diaa,
When I try to add a calculated item in your file I get the error "This PivotTable report field is grouped. You cannot add a calculated item to a grouped field".
Your date field is grouped by days and months. This grouping will prevent you adding any calculated items. If you want calculated items and grouped fields, then you need to add the calculated items to the source data. It cannot be done in the PivotTable. Or, add the date groupings for month and year to the source data as additional columns.
Mynda
Answers Post
1 Guest(s)
