SSAS / MDX Query - Add an extra dimension when using Order I wish to add an extra dimension to this query, so that I'm able to see the total amount of an item sold, per month/year:

SELECT  
 NON EMPTY   
 Order([Item].Children, Measures.[Total Line Value], DESC) ON COLUMNS,
 { [Total Line Value] } ON ROWS
 FROM        [Sales Analysis]


What I am looking for is something like so:

SELECT  
 NON EMPTY   
 Order([Item].Children, Measures.[Total Line Value], DESC), [January 2010].Children ON COLUMNS,
 { [Total Line Value] } ON ROWS
 FROM        [Sales Analysis]


This will eventually allow me to see the total sales of items for a particular month and year, but this throws an error as I'm not sure how to achieve it.

EDIT:

To clarify. The first query above works. It returns the grand total of items sold in order from highest to lowest BUT its for all time. I wish to restrict this to just show the order from highest to lower for just 1 month only, that being January 2010. I have a time field in my cube where it's possible to select the month and year like so: [January 2010].Children - I'm able to view this in excel, I just need to be able to view this in my application.

I have a similar query, this one returns all the sales, for each day of January 2010: 

SELECT  
NON EMPTY   { [January 2010].Children } ON COLUMNS,
            { [Total Line Value] } ON ROWS
FROM        [Sales Analysis]


I just want to split this down further to show each individual item's sales for that month, in order from highest to lowest.
I'm not quite sure what you're asking, but I think you want to do the following (correct me if I'm wrong):


You want to see a breakdown of sales by month, one row for each month, with a total for all months at the bottom.
You want to see the items across the columns, ordered by the item with the largest sales volume to the smallest. 


select non empty
       order ([Item].[Item].Children
             ,([Measures].[Total Line Value]
              ,[Date].[Month].[All])
             ,BDESC)
    on Columns
       non empty
      ,[Date].[Month].Children
    on Rows
  from [Sales Analysis]
 where [Measures].[Total Line Value]


The columns are each individual item, sorted by the total Line Value over all months, i.e. from all-time best seller to all-time lowest seller, with items having no sales at all excluded.

The rows are the months for all time where data exists.  You can use a set definition to specify any date range you want.  Note that this assumes the existence of a dimension called [Date].

This query will show the items in order of total sales across the columns and the sales for each month by item down the rows.  I'm not 100% sure if this is what you want; feel free to clairfy your question if I'm not on the right track.