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

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1093097-cubeset-condition.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).