Top1 und Top2 in je einer Spalte anzeigen

[merry2018]

Hello Togehter,

i ned your help, for get the korrekt formul in a diagram.

There are more departments, with each more people, and I would like to see only the oldest and the secound oldest each department. And that in a table like this:

Department	People	Age
Personal	Daniel	25
Personal	David	22
Management	Daniela	46
Management	Maria	40
Financial	Marion	35
Financial	Tom	17
Production	Alex	12
Production	Tina	11
Informatik	Tim	46
Informatik	Martin	45

There are more People: (which not shown in the Table):

Management	Max	35
Financial	Thomas	15
Financial	Franz	12
Production	Max	10

I tried to show the first Table, with the Formul: 

top(sum(Age),1,2)

But it doesn't work.

Regards 
Merry

[merry2018]

Respectively the table above I get over the constraint condition, I actually want the table to look like this:

Department	People TOP1	Age	People TOP2	Age
Personal	Daniel	25	David	22
Management	Daniela	46	Maria	40
Financial	Marion	35	Tom	17
Production	Alex	12	Tina	11
Informatik	Tim	46	Martin	45

[merry2018]

I found a formula, but it work not correkt:

=Aggr(if(rank( sum(Age) ) =1, Person &' ('&( sum(Age)) &')'), Depatrment, Age)

[merry2018]

I found a formula, but it work not correkt:

=Aggr(if(rank( sum(Age) ) =1, Person &' ('&( sum(Age)) &')'), Depatrment, Age)