I am getting the below error when I use an excel report from sharepoint. Error: Cross Tab (3): The Crosstab was set up for a Numeric field type and a String field was found.
I am not getting the sum option in the method of aggregating values.
However when I use an excel from my desktop I am able to run cross tab without any error.
Has anyone faced such issue?
Hello @JananiLakshmikumar
You will want to ensure the data type of the column that are you trying to sum in the cross tab is a numeric data type (double, int, fixeddecimal...etc)
Once you update this, you will be able to cross tab as expected.