crosstab difference of Avg

[pko123]

Hi,
I have a report where i need to show crosstab report,
summary average of sales for each quarter for each state, but along with that i also want to include another column or another crosstab that shows the difference of average of last 2 quarters. is this possible or i have to do manual crosstab.

e.g

      avg(Qtr1)  avg(Qtr2) Difference
NY    200         100        -100
CT    300          50        -250
IL    400         600         200

please suggest

 

[pko123]

moreover, i need a average for distinctcount of sites in States. Is this is possible with cross tab...I am using BOXI R2 version of crystal

 

[Tatertot45]

I guess i would do a manual cross tab, just for the sake of simplicity.