Dear Experts

Following are tow columns in Table1, Field1 has products and Fileld2 has quantity
A-----------60
A-----------45
A-----------20
B-----------40
B-----------35
B-----------85
B-----------15
C-----------12
C-----------18

In table I want to get sub totals of every category and then Grand Total at the end of the Table as below

A-----------60
A-----------45
A-----------20
sub total--125
B-----------40
B-----------35
B-----------85
B-----------15
sub total--175
C-----------12
C-----------18
sub total---30
Grand total-330

Please help