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