I figured it out based on the table that you put in your question. Thanks for including so much detail, it really helps!
The first part is to create a calculated field - I called it "Column Filter". You want to look for values where the month and year of the open claim month and award date are the same and only keep those. Here is the calculation:
if datetrunc('year',[Award Date]) = datetrunc('year',[Open Claim Month])
and datetrunc('month',[Award Date]) = [Open Claim Month]
then "Include" else "Exclude" end
Once you have this field created, drop it onto your Filters pane and only select "Include" (make sure "Exclude" is not selected). That will remove the values from the second September column. Now, if you remove the MY(Award Date) field from the Columns shelf in your viz, it'll show September and October, and only the number of claims that were both opened and awarded in that same month.
Let me know if you have any questions.
Hi S - if my answer worked for you can you please mark it as the correct answer so that others are able to search for this answer as well? Thanks!
My office system browsers do not display the "Correct Answer" button so I will when I'm in front of my home computer again. Thank you again.