with 
member [Measures].[Total Store Sales] as 'Sum(YTD(),[Measures].[Store Sales])'
select
	{[Measures].[Total Store Sales]} on columns,
	{TopCount([Product].[Product Department].members, 5 , [Measures].[Total Store Sales])} on rows
from Sales
where ([Time].[ 1997 ].[Q2].[ 4 ])

with
   member [Product].[All Products].[Drink].[Percent of Alcoholic Drinks] as '[Product].[All Products].[Drink].[Alcoholic Beverages]/[Product].[All Products].[Drink]', format = '#.00%'
select
   { [Product].[All Products].[Drink].[Percent of Alcoholic Drinks] } on columns,
   order([Customers].[All Customers].[USA].[WA].Children, [Product].[All Products].[Drink].[Percent of Alcoholic Drinks],BDESC ) on rows
from Sales
where ( [Measures].[Unit Sales] )

with 

set [Set0] as ' {[Product].[All Products].[Food], 
    descendants([Product].[All Products].[Food], 
                      [Product].[Product Name])}'
set [MeasureSet] as '{[Measures].[Sales Count], [Measures].[Store Sales]}'
set [Set1] as 'Extract(NonEmptyCrossJoin([Set0], [MeasureSet], {[Time].[1997]}, [Customers]), [Product])'

SET [Customers] AS 
 '{[Customers].[All Customers].[USA].[WA].[Redmond].[Mosha Pasumansky], 
 [Customers].[All Customers].[USA].[WA].[Redmond].[Alexander Berger]}'
MEMBER [Customers].Slicer AS 'SUM([Customers],Measures.CURRENTMEMBER)'

select 
crossjoin([Time].[ 1997 ].children, [MeasureSet]) on columns,
[Set1] on rows
from [Warehouse and Sales]
where ([Customers].Slicer)