Sorting members in MDX query based on member values

How to sort members returned in MDX query based on member values. Below are some examples:

SELECT Measures.MEMBERS ON COLUMNS,
ORDER({[Store].[Store City].[Beverly Hills]:[Spokane]}, [Store].CURRENTMEMBER.Name,BASC) ON ROWS FROM [Sales]

---

SELECT Measures.MEMBERS ON COLUMNS,
ORDER({[Store].[Store City].MEMBERS},Measures.[Sales Count], BDESC) ON ROWS
FROM [Sales]

---

select {[Measures].[Unit Sales], [Measures].[Store Cost]} ON columns,
crossjoin({[Product].[Product Category].Members},
{ORDER (except([Promotion Media].[Media Type].Members,
{[Promotion Media].[Media Type].[No Media]}),
[Measures].[Unit Sales],DESC)}) on rows
from Sales

Database : FoodMart 2000