with set[yrs]as{[Date].[Calendar Year].&[2012]:[Date].[Calendar Year].&[2013]}
member[Measures].[Flag]as case when nonempty([yrs],[Measures].[Internet Order Quantity]).count=0then null
when nonempty([yrs],[Measures].[Internet Order Quantity]).count=2then 1else 0end
--iif(nonempty([yrs],[Measures].[Internet Order Quantity]).count=2,1,null)
select ([Measures].[Flag],[Date].[Calendar Year])+([Measures].[Internet Order Quantity],[yrs])on 0,
non empty[Product].[Subcategory].[Subcategory]on 1from[Adventure Works]