Hi Everyone,

I have one problem. I need to rank and pick top 10 ResultCodes for each SCC sector. Ranking is coming perfectly whereas i'm not able to pick the top 10 Resultcodes per each SCC sector. When I used Topcount() i get only the 10 records from the entire lot.

Can anyone help me?


WITH
SET [Top Sector] AS ' GENERATE ( {[SCC].[All SCC]} , Order ( filter( [ResultCode].[Short Name].Members , [Measures].[Services] > 0 ) , [Measures].[Services] ,BDESC ) ) '
MEMBER [Measures].[Rank] as ' RANK( [ResultCode].CurrentMember , [Top Sector], [Measures].[Services] ) '
select { [Measures].[Services], [Measures].[Rank] } on columns,
{ [Top Sector] } on rows
from F_PROFIT


Thanks in advance.