I'm building a report where I need 2 totals. One is total sales from IN, which is the total of all records for a given date. The second total is the quantity sold from the same IN record, but only for certain items sold. In other words, for any given record in the table, I may or may not want to add the quantity sold to a total (or column) based on its item number.

I want both totals to show on the same report. I can use an "if" statement to report the quantity for one item but I can't find a way to filter for any of a variety of items.