How do I customize a report that shows Annual Sales of a Product/Service by Customer and to include Customer address information. I have chosen various "Sales by" reports, but cannot find one to include all of the columns I need.
Your original question is very clear to me. I understand what you want.
Unfortunately, such an option to customize the report as you want is not possible in QBO. You will find most of the reports in QBO are not filterable (or customizable) as you want. It's been like that for a while.