I have a question regarding cross tabs. I'm using Crystal reports 2008. My report has a cross tab with data set up by yearly quarters:

          Qtr 1   Qtr 2   Qtr 3   Qtr 4 Total
Joe        1       3       8       2     14
Sam        2       6       1       3     12
Lucy        1       2       3       1     7
Total       3       11      12      6     32

I want to add columns between the quarters that show the percentage increase or decrease from one quarter to the next:

          Qtr 1 %Change Qtr 2
Joe        1     +200     3       
Sam        2     +200     6       
Lucy        1     +100     2      
Total       3     +266    11      

The data represents simple sums from the report. A percent change formula is:

Quarter 2 - Quarter 1
        Quarter 1

How do I insert the percentage change formula into the cross tab and how would I write it in Crystal.

Thanks.

This worked great!! Thank you.