Aggr meed help

[Anonymous]

HI friends

i have a table student with two columns student id and marks.

Data set as shown below

student id.   Marks

15.                42

14.                39

13,                 22

11,               18

10.              90

9.                72

8.              33

7.              43

6.             11

5.              17

4.            38

3          66

2.       74

1,     10

now i wanted so consider latest 11 points i.e frpm15 to 5

then i need average of top 5 and avg of last six that

[sunny_talwar]

You need this in a text box object?

[sunny_talwar]

May be this in a text box object

For Top 5

=Avg(Aggr(If(Rank(If(Rank([student id]) <= 10, Marks)) <= 5, Marks), [student id]))

For Bottom 5

=Avg(Aggr(If(Rank(If(Rank([student id]) <= 10, Marks)) > 5, Marks), [student id]))

NOTE: 15 to 5 are just 10 data points so I used Bottom 5 instead of bottom 6 here

[Anonymous]

‌yes