Can you show us the SQL code?

I had a similar problem, but what I wanted was to group 2 different fields, and all I had to do was to add an UNION operator.

So this is a shot in the dark, if you have an UNION operator just remove it.