I originally posted in another topic but it was closed so was encouraged to start a new one (for those that answered the other post).
We are a franchise company. We need to compare the number inspections (orders) an new location books for their first 24 months they are open against previously opened locations. I need to work with both month and year from opening date. I have the opening date field [Contacts.Open-Date]. Each of our franchise locations start on different months and different years. How do determine the 1st month open, 2nd month, etc to the 24th month.
Once i calculate that, i need to then add up the Inspections performed. I already have a Measure that calculates the inspection counts called [Inspections].
The end result would look like this: