PDA

View Full Version : Issue with PivotTable and imported data through OData



ikozma
2015-03-06, 09:57 AM
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.