How to Insert Group in Subtotal

[koolguys4u]

Dear All,

Attached herewith the Excel file with self explanatory, i want to add 2012 rows after 2011 group total and then subtotal for 2012 and grand total will add the 2012 total also.

[bebo021999]

Just ungroup and remove substotal rows, and do Substotal again