We have a report that lists sales and revenue data which is sub summarized for each division. There are two tables: "Sales" amounts (records created as each contract is created) and "Revenue" amounts and goals (static data for each marketing rep). The report sorts by division (Corp & SE) and lists the current months' sales and goals by marketing rep. All the sales data and goal amounts are showing up fine, but I cannot get the related data to total by division, it only shows the grand total for both. I have duplicated the layout and based one on each table and the same thing happens; the related amounts do not total by division. Any ideas are welcome.
Message was edited by: RPaulH I have added a pdf of what I am seeing. Notice that the sales all total up correctly but the goal data (from the related file) does not.