Query

Hi

Ref No Qty

1.000000 643775.000000

1.000000 24140.000000

2.000000 40350.000000

2.000000 18195.000000

2.000000 20000.000000

I want taht it should display Subtotal after refno 1 & then subtotal of ref no2 and then Grand Total using grouping & rollup

Like This

1.000000 643775.000000

1.000000 24140.000000

Subtotal 668915.0

2. 40350

2. 18195

SubTotal 58545

Grand Total 66815+58545

Thanks