Hi , thanks for ur reply, i have another field month that can be used as in sort, but i need mdx code to use it . pls help me to sort sript to be used in above MDX query