Cubeset with condition

[JV0710]

Good Day

Please can I get help with the following query

I have the following cubeset formula and I would like to add a condition but cannot get it to work:

below is the formula:
=CUBESET("DD_MA","{ ORDER( { { { [Product].[Product].[Womens]} * {[Location].[UDA Brand].[All UDA Brand].[Brand1]} * { DESCENDANTS( [Location].[Location].[All Locations], [Location].[Location].[Store] ) } } }, ( [Time].[Time Season].[December_2018], [Measures].[Str_Sales] ), BDESC ) }","Stores")

I would like to add: where [Measures].[Str_Sales] >1000

Thanks in advance

Joe

 

[JV0710]

Good Day

Worked it out . . . Thanks very much

=CUBESET("DD_MA","{ORDER({FILTER({{{[Product].[Product].[Womens]} * {[Location].[UDA Brand].[All UDA Brand].[Brand1]} * {DESCENDANTS( [Location].[Location].[All Locations], [Location].[Location].[Store])}}}, ([Time].[Time Season].[December_2018], [Measures].[Str_Sales])>1000)}, ([Time].[Time Season].[December_2018], [Measures].[Str_Sales]), BDESC)}","Stores")