Add calculation

[#1]

Hi,

i want to ask about add row for calculate percentage.

I have a data like this:

Date               Qty     Trx_ID

3/6/2015          5          1

3/6/2015          3          2

4/6/2015          10        1

4/6/2015          7          2

I want to add one trx_id let's say Trx_ID 3 that the Qty will calculate the Qty(TrxID=2)/Qty(TrxID=1)

So the result i expect is like this:

Date               Qty     Trx_ID

3/6/2015          5          1

3/6/2015          3          2

3/6/2015          3/5       3     ------------------------- add this row

4/6/2015          10        1

4/6/2015          7          2

4/6/2015          7/10     3    ----------------------------add this row

Really appreciate your help.

Thanks

[jagan]

Glad to help you.

Regards,

Jagan.