Sum grouped and filtered

[#1]

I have one table with this data:

I want to add one column to have the number of Empoye in the pause "Journée" by ligne and Date prod.

I try

=count(total {$<DateProd,ligne,HoraireName={Journée}>} PersonneID)

can you help me?

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

You are very close to the syntax!

Count({< HoraireName = {'Journée'} >} TOTAL <DateProd, ligne> PersonneID)

That reads: "return how many PersonneID for each DateProd and ligne values where their HoraireName equals to Journée".

Hope that helps.

Miguel