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
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".
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.