Percentages in reports for group rows

[John Donovan]

Hi all
I am trying to show percentages in an Access 2007 report. The percentages MUST be a % of the total sales in THAT group, NOT the total sales of the WHOLE report.
eg In Group 1, row 3 shows sales of $33. The total of the group 1 sales is $999.I wish to show a result of 3.3% for row 3



The total sales of all groups total $1,200. My report shows row 3 as 2.75% (ie 33/1200)

How do I get 3.3% ?

Thanks

John D

[RuralGuy]

Each Group can have a footer with the total for that group in it.