Crosstab with quarters and years

[praveen224]

Hello,

I have a crosstab report as follows:

Q1 Q2 Q3 Q4
2009 2010 2009 2010 2009 2010 2009 2010
Sale1 100 200 100 200 100 200 100 200
Sale2 100 200 100 200 100 200 100 200
Sale3 100 200 100 200 100 200 100 200

I would like to add a total at the end that totals the years data - like:

Total
2009 2010
400 800
400 800
400 800

Any thoughts on how I can accomplish this?

Thanks
Praveen

 

[IanWaterman]

Just add another Crosstab leaving enough space for the existing one to grow.

Ian