-
Unable to retrieve the result
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|