num#(Year) AS Forced.Year,
Year AS Forced.Year_origin,
MyField AS Forced.MyField,
Value AS Forced.Value
UPDATE: Sample attached
Community_221153.qvw 152.2 K
How can I have my Year field as a numeric value?
The CROSSTABLE LOAD prefix will transform your field names to text values, so you need to interpret numbers using an interpretation function like Num#().
Num() is a formatting function, to format the text representation of numbers (which you don't have).
I don't think that you want to use the Date#() interpretation function. It will return a numeric representation, but with a internal date value, which I seldom use in my applications (edit: for year fields).
Hope this helps to understand better.