I have a table that is grouped by the field CellWCCode. The SQL Query is returning multiple rows (one each for the child item in the BOM), so for example, I might get 5 lines per CellCode. The field StdLabCost returns the one item for each grouped item, but now I want to total the StdLabCost for all of the CellWCCode. I have not figured out how to Sum all of the distinct values.
I attached sample data and the report.