MDX aggregate over lower level -

MDX aggregate over lower level -

i need aggregate on upper level filter on members lower one. study nowadays sales in every year filter on 1 specific month. illustration foodmart database , product dimension levels:

[product family] [product department]

mdx:

with fellow member [measures].[unit sales calculated] aggregate( intersect( descendants( [product].currentmember, [product].[product department], self ), [filtered product department] ), [measures].[unit sales] ) set [filtered product department] except( [product].[product department].members, [product].[drink].[alcoholic beverages] ) select non empty [measures].[unit sales calculated] on columns, non empty [product].[product family].members) on rows [sales]

this solution works performance rather poor. there better way write query?

aggregate mdx mondrian