I need to display a grand total both full total and a total based on the value of another displayed field. For example, I have a report that looks something like this:
Salesman Sales Amt Phone Sales?
Joe Bleaux 123,456.00 N
Jane Doe 54,756.24 Y
Fred Mertz 91,876.00 N
Sales Total 260,088.24
Phone Sales 54,756.24
How do I do this (and hopefully be able to display the total on the report header)