Hi Erik,

thanks for your time on this post and reply. I like the idea but i need to show 0.00 for march as i need to display last 6 months. the way you queried skips the month if it doesn't falls the start date and end date. I need to show 0.00 if it doesn't meets the condition

any suggestions please