Sales performance by gender of the customers with MDX Query
Jan 18
YouTube Converter
WITH set [Male] AS ‘Filter ([Customer].[CustomerID].Members,[Customer].CurrentMember.Properties(“GENDER”)= “M”)’
set [Female] AS ‘Filter ([Customer].[CustomerID].Members,[Customer].CurrentMember.Properties(“GENDER”)= “F”)’
member Customer.AggMale as ‘Aggregate([Male])
member Customer.AggFemale as ‘Aggregate([Female])
SELECT {[Measures].[SALES($)]} ON AXIS(0), {Customer.AggMale,Customer.AggFemale} ON AXIS(1) FROM [cubename]
