1 of 1 people found this helpful
You can create a calculated field like this
if year([date_field]) = year(today())
month([date_field]) = month(today())
then 0 else [sales] end
This will replace your current month data to zero thus affecting your grand total the way you like.
Hope this helps
Thanks a lot Jeevan, its working as i expected.