Pivottable help

  • Thread starter Thread starter Ngalula Michel
  • Start date Start date
N

Ngalula Michel

When any field is grouped in my pivottable, I can't add
any calculated item and vice-versa. Each time I receive
the error message: "Because a Pivottable report field is
grouped, you cannot add a calculated item to this
report..." I am stucked on this for months now; please
help.
..
 
Instead of grouping the data in the PivotTable, you maybe able to add a
field to the source data table, and calculate a group. For example,
instead of grouping by year, add a field named year, with the formula
=YEAR(A2). Add this field to the PivotTable, instead of the date field.
 
Back
Top