OK, friends! If either of you can solve this for me, you will be my hero for month! Lol
I have created a custom report that is sorted by Customer Number. Main tables involved are AR_Customer and AR_CustomerSalesHistory. I need for this ONE report to display the following:
1. Customer # and Name
2. Dollars Sold for Period 11 and 12, 2016 (totaled)
3. Dollars Sold for Period 1 to Date, 2017 (totaled)
4. Grand Total of Dollars Sold (combined) for #2 and #3.
This report would be a running total of Dollars Sold, basically, for Sales History from 11/1/2016 to Present, based on a specific Customer Type. If this is even possible, and you can provide instruction on how to accomplish this, it would be GREATLY appreciated! :)
- T. Helm