Hi i m i need to sort the report which looks like this ...............when some one clicks on top of any column the entire column need to be sorted even...

This is my query

SELECT NON EMPTY { [Measures].[Column Name 1],

[Measures].[Column Name 2 ],

[Measures].[Column Name 3], [Measures].[Column Name 4],

[Measures].[Column Name 5 ], [Measures].[Column Name 6], [Measures].[Column Name 7], [Measures].[Column Name...

Hi thanks for ur reply can u be little bit clear i m new to SQL .................and explain me in detail if possible

Hi i need to sort the report which has the similar query ...........interactive sort is working for one level.........i m trying to sort using MDX query can any one help...