Naveed Ul Haq
New Member
- Joined
- Dec 27, 2016
- Messages
- 19
- Office Version
- 365
- Platform
- Windows
- Web
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,
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,