To achieve that you should use query sim

To achieve that you should use query similar to this one: WITH set products as generate([Product].[Product Categories].[Product], [Product].[Product Categories].currentmember*topcount([Geography].[Geography].[City],3,[Measures].[Reseller Sales Amount])) select {[Measures].[Reseller Sales Amount]} on 0, non empty products on 1 from [adventure works]