grouping

[subbareddykm]

I have requirement like below :

For Company Code=A and Code=Code1 , I want top 5 Age values in my Age Field irrespective of my expression:

For Above case top 5 Ages are :   

39

35

31

27

19

For Company Code=B and Code=Code2 , I want top 5 Age values in my Age Field irrespective of my expression:

For Above case top 5 Ages are : 

87

86

83

79

75

Could you please help here , how to do it ?

[settu_periasamy]

Try this.

=Sum({<Age={"=aggr(rank(sum(Age)), Company,Age)<=5"}>}Val)

[shiveshsingh]

Hi Try this

=Sum({<Emp={"=aggr(rank(sum(Age)),Company,Age)<=5"}>}Age)

[subbareddykm]

Its is not working in app, for all Company Code, For some company's not coming top 5 when I select any company and Code then it is working

Is it possible to create it in Script level ?

[shiveshsingh]

Have you tried this?

=Sum({<Emp={"=aggr(rank(sum(Age)),Company,Age)<=5"}>}Age)