Pivot table won't sum value field in data model

[Naveed Ul Haq]

Hi Everyone,

I am trying to create a pivot table using the data model.

When I drag a field into the values section, it will only count it.

If I try to change the summarize setting to sum, I get the error message: We can't summarize this field with Sum because it's not a supported calculation for text data types.

Your anticipated help is highly appreciated.

Regards,

 

[RoryA]

Sounds like the data type of the column in the source is set to Text.

 

[Naveed Ul Haq]

Sounds like the data type of the column in the source is set to Text.

I have changed it to numbers, but still same problem

 

[RoryA]

Did you refresh the pivot table?

 

[Naveed Ul Haq]

Did you refresh the pivot table?

Yes

 

[RoryA]

How exactly did you change it to numbers?

 

[Naveed Ul Haq]

How exactly did you change it to numbers?

Sir, I know these simple processes. All I need is help to sum the column in pivot table using data model