Yearly percent change in crosstab

[hlmnsbuggy]

CR 11, oracle database

I have been searching for solution for yearly percentage change for a crosstab report. I have to come for your expert's help since I am a beginer for this
I have a financial crosstab report layout like this

Columns:
Accounting periods

Rows: Summarized Fields:
Sum of Cash
Sum of investments
Sum of Current liability
Sum of long term liabiltiy
sum of equity
…..


Currently, I use columns group options, I grouped accounting periods by less than or equal to 2006 and 2007. So I have 2006 and 2007 financial reports by $ amounts. Now I need add % change between the two years, How can I do that?
I saw once people do by adding another accounting periods to columns, wrote some sort of codes so last column will show percent changes. If you know would you please show me how to do that.

Thank you for all your help!!

Ann

 

[Madawc]

Use running totals to accumulate values for the two years, for the whole report. Do this using a formula that checks the year. Best make it flexible, like

Year({your.date}) = Year(Currentdate)

Year({your.date}) = (Year(Currentdate)-1)

In the report footer, use a formula field to compare the two/

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10