I am new to this forum and this is my first post.

 

I am in an urgent need of a solution for a report that I am working on.

 

I have created a cross tab report, with rows as categories and columns as containing different types/values of expenses, for different months in an year.

 

It would look something like that

 

                                           jan/2007                        feb/2007

                              travel    purchses   misc    travel    purchses   misc

Category1                35        175            25       50           225        35

 

I have done this using cross tab expert, by adding category1 as rows, the date as columns and sum of travels, purchaes and misc to the summarized fields.

 

Now I want to add the sum of all expeneses for the previous year as a column to the report for every category.  if i add the previous year expenses to the summarized fields, it is displayed for every month, but I want it as a separate columnn in the report.

 

Can anyone help me with some solution for this, it would of great help.

 

Thanks & regards

 

Ram