How to Show top 10 values for each group?

[#1]

Hi,

i have 3 fields

manager ,employee, salar

for under each manger  i want show top 10  salryed employess in in straight or pivot table

Please help me on

Thanks,

[JonnyPoole · Accepted solution]

For a straight table try this as the expression to show top 10 Salaries for each manager

if( aggr( rank(  sum(  Salary)),Manager,Employee) <=10, sum(Salary))

to actually show the rank as well

if( aggr( rank(  sum(  Salary)),Manager,Employee) <=10, aggr( rank(  sum(  Salary)),Manager,Employee))

[MK_QSL]

Dimension

1) Manager

2) IF(Aggr(Rank(SUM(Salary),4),Manager,Employee)<=10,Employee)

Expression

SUM(Salary)

[maxgro]

in a straight table you can also use dimension limit (in dimension limits tab)