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