Thanks a lot Loannis for the quick reply..
Your solution did not answer fully to the problem since the new aliases did not affect the dynamic table, i. e., once choosing one of the new aliases you made, one could not see them reflecting on the dynamic table.
I need to see the fields I'm selecting in the dynamic table as well. prior to the name change it worked perfectly.
the easiest way to do this even with entering functions:
LOAD Customername As Customer,
Salesvalue As Sales,
OrderdateSales As Date,
Year(OrderdateSales) As Orderyear,
Month(OrderdateSales) As Ordermonth
Customername, Salesvalue, OrderdateSales
A, 120, 12.7.2012
B, 200, 2.5.2012
C, 250, 17.2.2012
Greetings from Munich