I want a sales comparison monthwise where the comparison should come to till current date of each month.

 

For example: if doday is 10 Jan-2012 and i am giving a date range from Nov-2011 so i want the comparison monthwise but the comparison should be 1st to 10th of every month only. currently what is happening if i am giving a date range from Nov-11 to till date than it is taking full month of Nov & Dec & 10 days of the current month. whereas i want 10 days sales for each month if todays date is 10th.

 

If anyone can please help me on this.

 

Regads

Alex