LISTING 1: Determining Products Sold in Each State

with set [SoldInUSA] as 'Filter([Product].[Brand Name].Members,
 Not IsEmpty( ([USA], [Unit 
Sales]) ))'
 member [Measures].[SoldInState] as 'iif( IsEmpty(([Product]
.CurrentMember, [Unit Sales], 
[Customers].CurrentMember)), "No","Yes" )'
select [USA].children on COLUMNS,
  [SoldInUSA] on ROWS
from Sales
where ([SoldInState])