Hi

I have a cross tab report with Region and Customer on the left and Product on the top and below
product have current and previous year values with a growth percentage.
Example of layout below.

Region   Customer              Product
                                       2009  2010  growth
Region1  Customer1            
               Customer2
               Customer3
Region1 Sub Total

The growth percentage per Customer works fine, but not sure how to adjust it to calculate
the Region Sub Total growth correctly.
Below the formula I used to calculate growth on the Customer level:

if Sum ({@PreviousYear}, {Command.Customer})=0 then 0 else
(Sum ({@CurrentYear}, {Command.Customer})-Sum ({@PreviousYear}, {Command.Customer}))/Sum ({@PreviousYear}, {Command.Customer})*100

Any help wil be appreciated.

Regards