>You can do that with a table or with indexed view. To maintain the aggregate table you'll have to create a trigger(s) on the original table that will update the aggregate table. For indexed views see Designing Indexed Views in BOL. In both cases you will have to consider how much overhead it will create for original table INSERT/DELETE/UPDATE operations.

Indexed view seems a better choice in this case.
Thanks.