Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
qutesanju
Posting Yak Master
193 Posts |
 Posted - 2009-08-18 : 06:45:15
|
| I have one MDX query like this.............SELECT {[Measures].[Rolling Work History Costs]} ON COLUMNS,{Order({[Functional Location ID].[Level 02].AllMembers},[Measures].[Total Rolling Costs],DESC)} ON ROWSFROM "Cost Metricswhich is giving me correct result.but i need Rolling Work History Costs to sorted in descending values.like highest max value ,then second max,then third max etc.pls help me on this. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-08-18 : 08:07:19
|
| Dupe of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=131347 |
 |
|
|
|
|
|
ordering in MDX