Have a look a these two tables:
Let's create a MONTH_YEAR_AGO Column:
Have a look at the result:
....some thing is not right here....
Let's investigated the date dimension:
Looks alright? Have a look again without year and month:
We have a sorting issue here, so let's add a sorting column:
OK that's fixed, let's go back to our report:
Still a problem there, let's sort the chronological key:
That really fixed the problem!
Till Next Time