I don't know why but when I make a crosstable it automatically recognizes my price field as a date
so instead of 150 I get a 40213 date value or something.
how can that be fixed?
Upload your sample data excel for checking purpose
i found it.
reformat the whole sheet to general, and fix the date with Date(Num#(date_field)) AS Date afterwards
Retrieving data ...