calculations in levels ( per name and rank)

Hello everyone,

I have a dataset array with names,ranks and durations

[Name] [Rank] [Duration]

[xxxx ] [ MAS ] [6]

[xxxx] [MAS] [5]

[yyyy] [MAS] [5]

[yyyy] [MAS] [4]

[yyyy] [CO] [7]

[yyyy] [CO] [6]

xxxx 1st person

yyyy 2nd person

I want to calculate the sum of durations per name and per rank

1st person : 11 months as MAS

2nd person: 9 months as MAS and 13 months as CO

How can I achieve this?

Answer 1

[Guillaume]

Use findgroups and splitapply:

[group, idname, idrank] = findgroups(yourdataset.Name, yourdataset.Rank); 
result = table(idname, idrank, splitapply(@sum, yourdataset.Duration, group), 'VariableNames', {'Name', 'Rank', 'TotalDuration'})

[Vanessa]

Thank you very much!!

[Vanessa]

The results are wrong. I get larger results than the true ones. How can I fix this??

[Vanessa]

Sorry my mistake