Views calc will not do separate calculations based on the grouping field

views calc will not show separate calculations per grouping field. lets say you have this:

project1 (sum of all project 1 costs lets say equals $100)
project2 (sum of all project 2 costs lets say equals $200)
project3 (sum of all project 3 costs lets say equals $300)

if you set the grouping field to project name it WILL group costs by project name but the total for each project will be $600 and it SHOULD be $100 for project1, $200 for project2, and $300 for project3 ... and maybe if its not asking too much, the grand total.

has this been resolved? am i missing something?