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:41:23
|
| 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. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
qutesanju
Posting Yak Master
193 Posts |
Posted - 2009-08-18 : 06:59:53
|
| yeah...due to improper webpage loading it got posted double |
 |
|
|
|
|
|
ordering in MDX