Hi,

I required output in mdx not in sql server . Any how i got the solution FYI

WITH SET Top10Cust AS

[DimGeographyBuyer].[State].[State]

set topP as

Generate( {Top10Cust}, CrossJoin( {[DimGeographyBuyer].[State].CurrentMember},

TopCount([DimProduct].[MaterialId].[MaterialId].Members, 1, ([Measures].[DistributorSalesSum]))))

SELECT

{([Measures].[DistributorSalesSum]) } ON COLUMNS ,

non empty {topP}

ON ROWS

FROM (SELECT ( { [MarketYear].[MarketYearHierarchy].[MARKETYEAR].&[2014] } ) ON COLUMNS

FROM

[MyCube])