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.

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

Group your data as Region.
{Command.Customer} in the formula replace with the region group name.