How to provide rank
Hi All, I have created report for rank .for this i have used below query WITH SET [OrderedSet] AS ORDER ( NonEmpty ( ( [Employee].[EMPLOYEE NAME].[EMPLOYEE NAME].members,[Client].[PROGRAM NICK].[PROGRAM NICK].members, [Employee].[SUP NAME].&[SUSAN FOOTE]) , { [Measures].[SCHEDULEDTIME] } ) , [Measures].[SCHEDULEDTIME], DESC ) MEMBER [Measures].[Rnk] AS Rank ( ( [Employee].[EMPLOYEE NAME].CurrentMember,[Client].[PROGRAM NICK].[PROGRAM NICK].members,, [Employee].[SUP NAME].&[SUSAN FOOTE] ), [OrderedSet] ,[Measures].[SCHEDULEDTIME] ) SELECT {[Measures].[SCHEDULEDTIME], [Measures].[Rnk]} on 0, [OrderedSet] on 1 FROM ( SELECT FILTER([Date].[Date].MEMBERS,[Date].[Date].MEMBERVALUE>=CDate("7/1/2010") AND [Date].[Date].MEMBERVALUE<=CDate("28/10/2010")) ON 0 FROM [Team Lead] ) but get the result like this employee programnick measure rank A 30 35 Error B 30 25 Error C 30 15 Error A 25 56 Error B 25 25 Error C 25 12 Error and so on but i want result like this employee programnick measure rank A 30 35 1 B 30 25 2 C 30 15 3 A 25 56 1 B 25 25 2 C 25 12 3 please help amit
October 29th, 2010 12:38pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics