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]