agregats = {
const dt0 = ( aq.fromCSV(await FileAttachment('retro11.csv').text(), {delimiter:';'}) )
.filter(d => d.LNCONJ == "TOTAL"
&& d.CHAMP =='FM'
&& d.NBMAR !== 'so'
&& d.NBMAR !== null)
const dt = dt0
.groupby('ANNEE_1946_2018','MOIS')
.rollup({NBMAR: op.sum('NBMAR')})
const dt1 = dt.filter(d => d.MOIS == 'AN')
.select({'ANNEE_1946_2018': 'AN', 'NBMAR': 'TOT'})
.reify()
const dt2 = dt.filter(d => d.MOIS != 'AN')
.select({'ANNEE_1946_2018': 'AN'}, 1, 2)
const dt3 = dt2.join_left(dt1)
.derive({ date: d => op.utcdatetime(d.AN, d.MOIS, 0),
PCT : d => 100 * d.NBMAR / d.TOT})
.relocate('PCT', {after: 3})
.orderby(0, 1)
return {total_annuel: dt1, detail_mensuel: dt3, detail_mensuel_typmar: dt0}
}