How to create PNL filed ?

P&L Question

Hi Amit

I have below raw data

GL_CODE AMT

1....................10

10..................10

20...................-5

30...................-5

40..............,.,,,2

50................,.,2

60..,,,......,,,,,,,,-3

70...,,,......,,,,,,-,3

How should I convert to below by add PNL Field :-

GL_CODE AMT  PNL

1....................10.....REV

10..................10.....REV

20...................-5....,.COGS

30...................-5....,.COGS

40..............,.,,,2......OTH_INCOME

50................,.,2......OTH_INCOME

60..,,,......,,,,,,,,-3......EXP

70...,,,......,,,,,,-,3......EXP

So that I can get the final result :-

REV ..... .............20

COGS ...............10

OTH_INCONE....4

EXP .....................5

NP .......................1

Above table use straight table

My question is how to recode PNL from GL_CODE ?

Remark :-

NP = NET_ PROFIT = REV-COGS+OTH_INCOME-EXP

REV +value 

COGS -ve value 

OTH INCOME + ve vakue

EXP -ve value 

The actual raw data for REV , GL_CODE is from 1 to 60 . But for example purpose to use 1 to 10

COGS CL_CODE is start from 100 and end 110 , but all run in sequence. 

Paul