Pivot tables
Solved
Martin
-
Martin -
Martin -
Hello,
I have been using a spreadsheet for several years that contains several pivot tables. The formulas and the type of data have been the same for a long time, but today the following error message appears when I try to change the format of the fields from number to sum. Message: "Sorry... We cannot summarize this field with Sum because it is not a calculation supported for Text data types."
I checked my source data but they are all numbers and not text...
Thank you for your help.
I have been using a spreadsheet for several years that contains several pivot tables. The formulas and the type of data have been the same for a long time, but today the following error message appears when I try to change the format of the fields from number to sum. Message: "Sorry... We cannot summarize this field with Sum because it is not a calculation supported for Text data types."
I checked my source data but they are all numbers and not text...
Thank you for your help.
