SQlite3 - Select showing all cols with sub total after each category group

Hi,

In MySql there is a way to do this without too much hassle. See attachment Target.txt.

The best I can produce in SQlite3 is: See attachment Actual.txt.

Can someone tell me what query I can use to accomplishTarget.txt format?

Thanks in advance R.
Attached Files

	Actual.txt (1.5 KB)
	Target.txt (691 Bytes)