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
Nothing attached
sorry I attached the massage again
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
Hi Mynda
i attached the Excel file containing the data and I hope to find the solution
Diaa
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
Hi Mynda
thank you for your effort 
Diaa
