Cross Tab error

Question

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?

gautiergodard · Answer

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.