Hello friends !!!

my question is -
what i need in reports-- on dynamic columns for peroid 2009-10, 2010-11 ,so on.. my summary fields are col1, col2 for each period. and on grand total , i want to use formula so row grand total for col1 needs formula like              
in period 2010 (col1) + in period 2009 (col1), in period 2010(col2)+ in period 2009 (col2) like this... means if period like 2005,2006,2007 then i want formula for last year 2007 & previous year 2006.

How to do this in crystal reports in cross tab or else ???
exactly looks like below :

     --this year is dynamic columns
     2009        2010            %changeA      %change B
---------------------------------------------------------     
       A2 B2      A3    B3   (A3-A2)/A2     (B3-B2)/B2
---------------------------------------------------------
dataX 2   1       5     8       1.5               7
dataY 4   5       5     6       0.25              0.2
dataZ 4   2       9     8       1.25              3
--------------------------------------------------------



plz reply..

Edited by pratibha - 05 Jan 2012 at 1:01pm

just create a formula for each field  like
A2
if table.datefield in date(2009,1,1) to date(2009,12,31) then table.field_you need to summerize

A3
if table.datefield in date(2010,1,1) to date(2010,12,31) then table.field_you need to summerize

etc

your  %changeA    would be just like you wrote it (A3-A2)/A2

then just put them into your crosstab