LISTING 3: Determining Brands Sold During the Past Three Quarters

with set [LastQuarter] as 'Tail(Filter([Time].[Quarter].Members, Not 
IsEmpty([Time].CurrentMember)),1)'
 set [Last3Quarters] as ' [LastQuarter].item(0).item(0).Lag(2) : [LastQuarter].item(0).item(0)'
select [Last3Quarters] on COLUMNS,
 Non Empty Union(Descendants( [Food], [Product].[Brand Name] ),
 Descendants( [Drink], 
[Product].[Brand Name] )) on ROWS
from Sales