Count Rows, Running Total with a Filter

[Anonymous]

I'm in need of some assistance and hope that I can explain my challenge. Below is an example of my table (labeled Dataset) which I am trying to get the running sum each month. Based on my Dataset table I would like to show the count in the Running Sum column.

Results Table

Month	Count Proj Created	Count Proj Closed	Running Sum
Apr	3	0	3
May	2	1	4
Jun	2	0	6

Dataset

Date	Number	Category	Date Month	Date Year
4/2/22	374883	Proj Created	Apr	2022
4/15/22	375377	Proj Created	Apr	2022
4/3/22	561879	Proj Created	Apr	2022
4/28/22	236854	Proj Blue	Apr	2022
5/3/22	869541	Proj Created	May	2022
5/16/22	587764	Proj Created	May	2022
5/30/22	954821	Proj Closed	May	2022
6/28/22	658841	Proj Created	Jun	2022
6/4/22	685897	Proj Created	Jun	2022

Thanks,

DK

[ryan_mayu]

@Anonymous 

what's the logic of calculation?

it looks like we have 3 project in may, why your result is 2?

why we dont have any project created in Apr? it looks like at least 3 . btw, don't know the meaning of project blue.

how to define a project is closed? i only see one closed in May, why your result is larger than 1?

[Anonymous · Accepted solution]

I wasn't sure how to describe what I needed but we found a way to get the data we need.Thank you for your response ryan_mayu.