MDX Puzzle - 15 Mar 2000

In the FoodMart Sales cube, the Name level of the Customers dimension has a member property called Gender. How would you write an MDX query that shows unit sales for male and female customers for drink products sold in California? The trick is to do this without creating a virtual dimension on the Gender property.