Please can someone help me with this query?
I am trying to create a pivot with a dataset 753 rows and 17 columns.
The problem I am encountering is when I tried to change the “Count” field to a “Sum” for the YTD Mar15 Value.
The below error prompt appears "We cant summarize this field with Sum because it' not a supported calculation for Text data types".
I have tried to change the format of the data to Text, General, Number and Custom but with no success. I even deleted all of the unsupported characters in case these were the problem.
So what is it that I am doing wrong? Can someone help me?
Many thanks,
My-Linh
I am trying to create a pivot with a dataset 753 rows and 17 columns.
The problem I am encountering is when I tried to change the “Count” field to a “Sum” for the YTD Mar15 Value.
The below error prompt appears "We cant summarize this field with Sum because it' not a supported calculation for Text data types".
I have tried to change the format of the data to Text, General, Number and Custom but with no success. I even deleted all of the unsupported characters in case these were the problem.
So what is it that I am doing wrong? Can someone help me?
Many thanks,
My-Linh