Cumul Total by month

[Sofinobi]

Hello All
i have Client Table with creation dates, statut (if the client is active or not), and if the client is not active i have the "Last Modification Date" column to show the inactive date.

i want to represent the number of active client in a line chart by months, so i need the cumul sum of active client
please if you can help
the result wanted, see image

Nb client actif by month 

thank you so much

[Aburar_123]

Hi @Sofinobi ,

Please pull the date field to the X-Axis, ClientID to Y-Axis (Make it as Count) then place the Active flag to Visual level filter and make it as 'Y'.

[Sofinobi]

thank you o much for the answer, but sorry i don't understand your approach,

can you explain me more about that active flag?
thank you