Seperating a month dimension that accepts 2 fields by those fields
So I have a data set of IT tickets that has one column labeled OpenDate and one labeled CloseDate. I want to create a bar chart that has two dimensions a bottom level of month and then for each month 2 columns one that shows how many tickets were opened and how many were closed. I think I am on the right track with my month dimension its a huge nested if statement that accepts both the OpenDate and the CloseDate, it look something like this:
My problem then arises with the next dimension. I can create a comparison of the amount of tickets closed vs left open is I use the created field below
IF(Month(ClosedDate), 'Closed', 'Still Open')
However what I would really like are 2 total counts one of the total number of tickets closed and one of the total opened for that month. So far I have been unable to add a third dimension so it seems as though what ever must be done must be done in this created dimension. However, I'm open to any suggestions.