Sage 100

You can use "Calculated Measures" to add a row or column to a crosstab, but on your rows it won't repeat for each group. Can you switch the years to be columns and the months to be rows? In that case a single Calculated Measure could be added to show a calculation between years. Below is an example where I added three measures. The value difference and percentage difference between columns and the average of all columns.

If you've never used Crystal's calculated measures you could check out this video.

------------------------------
Dan Burleson
Software Consultant
Connex Software
------------------------------

You can use "Calculated Measures" to add a row or column to a crosstab, but on your rows it won't repeat for each group. Can you switch the years to be columns and the months to be rows? In that case a single Calculated Measure could be added to show a calculation between years. Below is an example where I added three measures. The value difference and percentage difference between columns and the average of all columns.

If you've never used Crystal's calculated measures you could check out this video.

------------------------------
Dan Burleson
Software Consultant
Connex Software
------------------------------

And... pivoting wouldn't work for this one.  Rats.

You can use "Calculated Measures" to add a row or column to a crosstab, but on your rows it won't repeat for each group. Can you switch the years to be columns and the months to be rows? In that case a single Calculated Measure could be added to show a calculation between years. Below is an example where I added three measures. The value difference and percentage difference between columns and the average of all columns.

If you've never used Crystal's calculated measures you could check out this video.

------------------------------
Dan Burleson
Software Consultant
Connex Software

I think that only leaves a standard summary Crystal report with a dozen variables to calculate the difference between the current and previous year.

And... pivoting wouldn't work for this one.  Rats.

You can use "Calculated Measures" to add a row or column to a crosstab, but on your rows it won't repeat for each group. Can you switch the years to be columns and the months to be rows? In that case a single Calculated Measure could be added to show a calculation between years. Below is an example where I added three measures. The value difference and percentage difference between columns and the average of all columns.

If you've never used Crystal's calculated measures you could check out this video.

------------------------------
Dan Burleson
Software Consultant
Connex Software

So it gets better - they currently have a prompt for start and end year (so it can be more than 2) and start and end MONTH if they only care about April - October, say.

I think that only leaves a standard summary Crystal report with a dozen variables to calculate the difference between the current and previous year.

And... pivoting wouldn't work for this one.  Rats.

You can use "Calculated Measures" to add a row or column to a crosstab, but on your rows it won't repeat for each group. Can you switch the years to be columns and the months to be rows? In that case a single Calculated Measure could be added to show a calculation between years. Below is an example where I added three measures. The value difference and percentage difference between columns and the average of all columns.

If you've never used Crystal's calculated measures you could check out this video.

------------------------------
Dan Burleson
Software Consultant
Connex Software

You could define the dozen Global variables as arrays, put them in a group footer "b", increment an index for each occurrence of the group (i.e. year), accumulate the differences,  and supress the section if all twelve differences for the current array level are empty. Reset the index on each customer group header.

So it gets better - they currently have a prompt for start and end year (so it can be more than 2) and start and end MONTH if they only care about April - October, say.

I think that only leaves a standard summary Crystal report with a dozen variables to calculate the difference between the current and previous year.

And... pivoting wouldn't work for this one.  Rats.

You can use "Calculated Measures" to add a row or column to a crosstab, but on your rows it won't repeat for each group. Can you switch the years to be columns and the months to be rows? In that case a single Calculated Measure could be added to show a calculation between years. Below is an example where I added three measures. The value difference and percentage difference between columns and the average of all columns.

If you've never used Crystal's calculated measures you could check out this video.

------------------------------
Dan Burleson
Software Consultant
Connex Software