According to your input, seems like you need to reorganize data structure.
As you mentioned, Currently it's based on key fields of "Project" which has projected date and actual date.
What you need is "Period" as a key how many projected project and how many actual project.
To do that,
Duplicate data source.
Original one is for projection, and new one is for Actual
Rename both data source for recognition.
Under "Act" data source
Create calculated field
[Actual Closure Period]
Under "Proj" data source
[Projected Closure Period]
Link "Period" between two data source, but don't link anything else.
Rename "Number of Records" of both data source to
"act Count" and "Proj count"
Put fields as below.
Proj Act_9.0.twbx 43.9 KB
Thank you so much Shin. This is what I needed
You are welcome, this was little bit tricky situation . good luck.