When I connect to an Excel datafile, The measures are being reorganized by alphabetical order. How can I keep the same order as the original input file?
You can do this by clicking the drop down menu next to Dimensions in the data window and select Sort by Data Source Table:
Hope this helps!
Retrieving data ...