<p>I have a requirement to show below rows in a crosstab</p>
<p> </p>
<p>MTD</p>
<p>Previous MTD</p>
<p>Previous 6 Months MTD</p>
<p>Previous Year MTD</p>
<p> </p>
<p>I can calculate it using the relative time periods but I only wanted to show as per the latest date. So for e.g. if today is 20th April 2017</p>
<p> </p>
<p>MTD will be 1st April to 20th Apr</p>
<p>Previous MTD will be 1st Mar to 20th Mar</p>
<p>...</p>
<p>Previous Year MTD 1st Apr 16 to 20th Apr 16</p>
<div> </div>
<p> </p>
<p> </p>
