Issue with PivotTable and imported data through OData

ikozma

New member
Joined
Mar 6, 2015
Messages
1
Reaction score
0
Points
0
Hi,

My problem is that after I import data to Excel 2013 through OData all cells are represented as text.
This is not ok because in PivotTable when I try to create a report by dragging the dimensions/measure in rows/columns I cannot sum the double values, Excel throws an error: "We cannot summarize this field with Sum because it's not a supported calculation for Text data types."

In the OData metadata XML the types are correctly set, it seems that Excel does not handles it correctly.

Any help would be appreciated.
 
Back
Top