Is it possible to sum the sub totals of a group without reading the whole table in BIDS?

I have to check the results, using SQL I can fix it.

The issue was using SSRS for my colleague .

Thanks

Hi, thanks.

My example had no DDL.

Regards,

Edgar

no, sorry. can't be a simple sum.

Well, in the sql table given. A user has different tasks, and col2 is suppose to represent seconds in task, but it was added another column with the total per...