I have a database that captures all potential and actual sales and returns. What I would like to do is on the Sales Report have Gross Sales by month, under that have whatever was returned and for a total line have the net sales. The gross sales needs to be by salesperson then a Gross Sales Total, under that I need returns (not by salesperson but total for that month). Then the last line would be net sales.
Jan Feb Mar .................