WITH member AverageSpend AS
[Measures].[Amount] / [Measures].[TRANSACTION COUNT]
SELECT
  AverageSpend ON COLUMNS,
  {
    [Customer].[Sex].[Female],
    [Customer].[Sex].[Male]
  } ON ROWS
FROM [Sales]
WHERE ([Shop].[Apple])