Crosstab percentage calculations on subtotals

[paulsparrow]

I have a crosstab report where I am calculating a percentage.  I now want subtotals to sum the above raw data and calculate a subtotal percentage

IE:
group 1
  team 1   23%  (x/y)
  team 2   30%  (x/y)
    subtotal   x%  (sum x / sum y)
group 2
group 3

[paulsparrow]

Problem solved.  If you click on the "total" cell and go to properties I set the aggregate method to "Aggregate" and Use Set Aggregation to "No".

[qvixote]

Thanks Paulsparrow for coming back an tell us how you've solved the problem, so anyone with the same problem in the future can read the solution.