Count Total group by

zet — Sat, 16 Nov 2024 17:46:36 GMT

Hello,

I have this table

I'm using this expression to calculate NbPositions: count(Aggr(count(Source),Date_Circulation,Numero_Sillon,CR_CI_CH,Type_Horaire,Source))

and I want to add new column using new expression to count total by type like this :

Thanks in advance.

Re: Count Total group by

Kushal_Chawda — Wed, 25 Nov 2020 16:22:46 GMT

@zet try below

count(total <Type> Aggr(count(Source),Date_Circulation,Numero_Sillon,CR_CI_CH,Type_Horaire,Source))

zet — Wed, 25 Nov 2020 16:27:54 GMT

Thanks a lot !