SUBTOTALS IN EXCEL TEMPLATE - Review the actual scenario inside

Hi All,

I want to generate a report as in below format. The challenge I am facing is to print subtotal after every item category. If you observe 60 is total of item category A. This has to print at the last record of the item cateogory, before the record with next value for item category starts.

Let me know how we can achieve in Excel templates.

   

Item Category	Item	qty	subtotal
A	ITEM1	10
A	ITEM2	20
A	ITEM3	30	60
B	ITEM4	20
B	ITEM4	30
B	ITEM4	40
B	ITEM4	60	150

Thanks!