Forum Discussion
Dataformat.Error: We couldn't convert to Number
It could be that there's an earlier step in your query that's trying to convert that column to a number, try looking to see whether there is and removing it
It could be that there's an earlier step in your query that's trying to convert that column to a number, try looking to see whether there is and removing it
I had a similar issue today. WOuld like to pivot a set of data ,
e.g. Area A/B/C in column 1, Sales X/Y/Z in column 2,
into Column 1 (Area A /Sales X), Column 2 (Area b/Sales Y), COlumn 3 (Area C/Sales Z).
After reading this trail, I realized pivoting can only be made, after converting column SALES XYZ from numbers into text format. But why is that? Isn't the purpose of the pivot to add up numbers and that could only be made via number format?