I am using Crystal 10 with SQL Server.
Data sample below is currently what I am producing.
With this sample the 5 week Total Sales and 5 week Moving Avg are in the same grouping.
Currently being group by Quarter.
What I am looking to include on this report is on each grouping take the avg total from the next quarter and do % change on the totals.
ex.
12/30/2005 avg total subtract 03/31/2006 avg total and divide result by 03/31/2006 and show in the line with 12/30/2005.
Please let me know if you need further information.
A B C D E F G TOTAL
5 Week Total Sales as of 12/30/2005 $10 $10 $10 $10 $10 $10 $10 $70
5 Week Moving Avg $2 $2 $2 $2 $2 $2 $2 $14
5 Week Total Sales as of 03/31/2006 $10 $10 $10 $10 $10 $10 $10 $70
5 Week Moving Avg $2 $2 $2 $2 $2 $2 $2 $14
5 Week Total Sales as of 06/30/2006 $10 $10 $10 $10 $10 $10 $10 $70
5 Week Moving Avg $2 $2 $2 $2 $2 $2 $2 $14
5 Week Total Sales as of 09/30/2006 $10 $10 $10 $10 $10 $10 $10 $70
5 Week Moving Avg $2 $2 $2 $2 $2 $2 $2 $14
5 Week Total Sales as of 12/31/2006 $10 $10 $10 $10 $10 $10 $10 $70
5 Week Moving Avg $2 $2 $2 $2 $2 $2 $2 $14
5 Week Total Sales as of 03/31/2007 $10 $10 $10 $10 $10 $10 $10 $70
5 Week Moving Avg $2 $2 $2 $2 $2 $2 $2 $14
5 Week Total Sales as of 06/30/2007 $10 $10 $10 $10 $10 $10 $10 $70
5 Week Moving Avg $2 $2 $2 $2 $2 $2 $2 $14
5 Week Total Sales as of 07/16/2007 $10 $10 $10 $10 $10 $10 $10 $70
5 Week Moving Avg $2 $2 $2 $2 $2 $2 $2 $14
Data sample below is currently what I am producing.
With this sample the 5 week Total Sales and 5 week Moving Avg are in the same grouping.
Currently being group by Quarter.
What I am looking to include on this report is on each grouping take the avg total from the next quarter and do % change on the totals.
ex.
12/30/2005 avg total subtract 03/31/2006 avg total and divide result by 03/31/2006 and show in the line with 12/30/2005.
Please let me know if you need further information.
A B C D E F G TOTAL
5 Week Total Sales as of 12/30/2005 $10 $10 $10 $10 $10 $10 $10 $70
5 Week Moving Avg $2 $2 $2 $2 $2 $2 $2 $14
5 Week Total Sales as of 03/31/2006 $10 $10 $10 $10 $10 $10 $10 $70
5 Week Moving Avg $2 $2 $2 $2 $2 $2 $2 $14
5 Week Total Sales as of 06/30/2006 $10 $10 $10 $10 $10 $10 $10 $70
5 Week Moving Avg $2 $2 $2 $2 $2 $2 $2 $14
5 Week Total Sales as of 09/30/2006 $10 $10 $10 $10 $10 $10 $10 $70
5 Week Moving Avg $2 $2 $2 $2 $2 $2 $2 $14
5 Week Total Sales as of 12/31/2006 $10 $10 $10 $10 $10 $10 $10 $70
5 Week Moving Avg $2 $2 $2 $2 $2 $2 $2 $14
5 Week Total Sales as of 03/31/2007 $10 $10 $10 $10 $10 $10 $10 $70
5 Week Moving Avg $2 $2 $2 $2 $2 $2 $2 $14
5 Week Total Sales as of 06/30/2007 $10 $10 $10 $10 $10 $10 $10 $70
5 Week Moving Avg $2 $2 $2 $2 $2 $2 $2 $14
5 Week Total Sales as of 07/16/2007 $10 $10 $10 $10 $10 $10 $10 $70
5 Week Moving Avg $2 $2 $2 $2 $2 $2 $2 $14