Thank you, i am failing to post the reduced file through the reply option, i will post a new discussion on the same so that i am able to attach the reduced file.
I have come across a solution, in order to provide a good moving annual total (MAT) analysis. The solution is called As-Of table. A very good example is provided here by Henric Conström:
Additionally, by using DateDiff (difference between the two dates), you might create different flags for flagging current 3months, 6months, 1Year, Ytd, etc.
.png "itec_pao"){kind=avatar}
