I am looking to create a single query for the following:

I would like to capture a list of all products and their descriptions with ytd total, previous month, current month, and projected for next month.


All information is held in the same view as follows:
Product
ProductDescription
DisburseDate