About Rank Function?

[#1]

Hi Folks,

I have a Table with Emp_ID,Sal,Deptno

I want to show only top 10 Salaries Deptno or Emp_ID

I tried Rank(sum(Sal),10) --It is not giving the proper result what i expect.

Can u plz suggest me this using Rank function only.

I tried aggr(rank(sum(Sal))<10,Deptno) --- both are not working properly.

Thanks,

rakesh

[priyalshah9779]

Hi

I have try to achieve this , Let me know if this helps

Thanks

Priyal

[#3]

Hi,

Can please post the logic Here

[priyalshah9779]

Hi

Dimension: DepartmentName,Employeeid

Expression :=IF(Rank(Total Sum(Salary))<4,Sum(Salary))

Thanks

Priyal

[anbu1984]

Dim: DeptNo

Expr: If( Rank(Aggr(Sum(Sal),DeptNo))<10,Sum(Sal))

[jpapador]

Like others have suggested:

Dimensions: Dept No and Emp No

Expression:

If(Rank(Sum(TOTAL Sal),4) <= 10, Sum(Sal))

[MarcoWedel]

you could also use dimension limits in your chart:

Chart properties/Dimension limits/show only largest 10 values

hope this helps

regards

Marco

[#8]

Hi,

Thanks for ur reply.

but it's not giving proper result

[#9]

Hi,

but it is giving the other departments also

[#10]

only using with rank() i want