This is the un-ordered query I have so far. This was an auto built query
from reporting services, but looks how i want it except for the ordering.
SELECT
NON EMPTY
{ [Measures].[AvgVolume],
[Measures].[Number of Trades],
[Measures].[AvgNumTrades],
[Measures].[Volume] } ON COLUMNS,
NON EMPTY
{([Date].[tradeDate].[tradeDate].ALLMEMBERS *
[User].[User].[User].ALLMEMBERS *
[Commodity].[Commodity].{Commodity].ALLMEMBERS ) }
DIMENSION
PROPERTIES MEMBER_CAPTION,
MEMBER_UNIQUE_NAME ON ROWS
FROM [UserStats]
CELL PROPERTIES
VALUE,
BACK_COLOR,
FORE_COLOR,
FORMATTED_VALUE,
FORMAT_STRING,
FONT_NAME,
FONT_SIZE,
FONT_FLAGS
How do I do it?