I have a report with the Grouping on the Load date. AM trying to get the count of the claims for each month. So i have formulas created for each month. i.e. COuntnovember,CountDecember etc. i.e

If i pull in the formuals in the group footer i get the results as following

 

PH            November            December   January     February

GF2                     0                      0              2710          0

GF2                     2343                0               0                0

 

I dont know why i see 2 rows created. I dont want to see the zeros in the group footer. I need something like this