Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Glad to help you.
Regards,
Jagan.