Returns: A set of tuples.
The following example uses the Except function to retrieve the sales amount for all product departments with a name containing the word "GIRL" but not the word "TEEN."
SELECT {[Price Analysis].[Measures].[Sales Amount]} ON AXIS(0), {Except(Filter([Price Analysis].[Product].[All Products].Children, InStr([Price Analysis].[Product].CurrentMember.Name, "GIRL") > 0), Filter([Price Analysis].[Product].[All Products].Children, InStr([Price Analysis].[Product].CurrentMember.Name, "TEEN") > 0))} ON AXIS(1) FROM [Price Analysis]
Product | Sales Amount |
---|---|
GIRLS JUNIORS | 37848.56 |
GIRLS SCHOOL APPAREL | 38151.76 |