How to sum of sales over specified period dynamically
This is regarding set analysis query. I have a Orders table whic contain contain order details,sales amount and date key. I have another date table.The order table and date table are joined with the help of date key. I need to find the sum of sales amount over a range. From Year and To Year parameters need to be added in the report. The sum of sales have to be calculated based on the From Year and To year parameters. Can any one let me know how it can be implemented!!