<div>
Are you trying to run this as a rolling 24 month report where the last 12 months are &quot;this year&quot; and the 12 months before that are Last Year?<br />
<br />
In this report are you trying run as 1 April 2014 through 30 March 2015 is this year and 1 April 2013 through 30 March 2104 is Last Year?<br />
<br />
If so you have to use the reporting period to determine which 12 months to use since you actually have 3 Transaction years in the data.<br />
<br />
You have data from April 2013 through March 2015<br />
&nbsp;April 2013 Through Jun 2013 is TransYear 2013<br />
Jul 2013 Through Jun 2014 is TransYear 2014<br />
Jul 2104 through Mar 2015 is TransYear 2015<br />
<br />
Check the report I modified and the last year/ this year sales<br />
<br />
I added 2 formulas to show the minimum accounting date and period in the report<br />
Names start with zz<br />
<br />
mlmcc<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/09_w38/1384983/MatrixSalesByProduct12Months-Rev-1.rpt" target="_blank" class="file-inline" title="Revised report (213 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>MatrixSalesByProduct12Months-Rev-1.rpt</a>
</div>


MatrixSalesByProduct12Months-Rev-1.rpt

<div>
Please see below:<br />
<br />
<i>Are you trying to run this as a rolling 24 month report where the last 12 months are &quot;this year&quot; and the 12 months before that are Last Year?</i><br />
Yes that is correct.<br />
<br />
<i>In this report are you trying run as 1 April 2014 through 30 March 2015 is this year and 1 April 2013 through 30 March 2104 is Last Year?</i><br />
Well no, the year should be July 2014 to June 2015 and July 2013 to June 2014<br />
<br />
The financial year reporting periods are July to June.
</div>


<div>
Hello again, I have checked the revised file and the LYSales column doesn't seem to pick up the previous period of July to June.
</div>


<div>
The way you have it written you are pulling the data I mentioned.<br />
<br />
How are the users going to specify which years to run for?<br />
<br />
What date should be used? &nbsp;Period 36 corresponds to Accounting Date March 2015<br />
If you use the Period you will need to either accept the potential for having 3 years or you will have to calculate the starting period. &nbsp;The other alternative is to limit the periods the user can select to the June months so you always get a full year.<br />
<br />
If period 36 is supposed to be the end of the year , then there must be &nbsp;a different date to show for the report<br />
<br />
I attached a revised report that I added a Cross Tab to show the data in the report.<br />
<br />
mlmcc<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/09_w38/1385208/MatrixSalesByProduct12Monthsrev2.rpt" target="_blank" class="file-inline" title="Revised report (304 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>MatrixSalesByProduct12Monthsrev2.rpt</a>
</div>


MatrixSalesByProduct12Monthsrev2.rpt

<div>
The User enters the date range via the accounting software before the report runs.<br />
<br />
The saved data is only an example.<br />
<br />
LY should be last 12 month blocks as opposed to LFYear (July to June end) .<br />
<br />
Sorry in past posts I had this stated as a financial year, it isn't, it should be blocks.
</div>


<div>
What does the application pass to the report for the date range or period<br />
<br />
mlmcc
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I’m wondering if I could please get some help with my Crystal Report?<br />
The 5th column in from the left called “LYSales” is not calculating the correct last year sales values and I am unsure why.<br />
<br />
The sales financial period in Australia is from July to June.<br />
<br />
I have saved the report with data.<br />
<br />
File attached.<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/09_w38/1384976/MatrixSalesByProduct12Months.rpt" target="_blank" class="file-inline" title="MatrixSalesByProduct12Months.rpt (213 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>MatrixSalesByProduct12Months.rpt</a>
</div>
</div>


MatrixSalesByProduct12Months.rpt

Hello,

I’m wondering if I could please get some help with my Crystal Report?
The 5th column in from the left called “LYSales” is not calculating the correct last year sales values and I am unsure why.

The sales financial period in Australia is from July to June.

I have saved the report with data.

File attached.

LYSales Column of Crystal Report (Last Year Sales Column)

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.