10 Replies Latest reply: Sep 12, 2014 10:34 AM by pavan Kumar RSS

    How to flag column values


      Hi Friends,

       

      I have a data set like this

      A B C Code Amount

      1 2 3  PC 900

      1 3 4  PM  800

      1 2 4   TM 800

      1 2 6  PC 800

      1 3 4 PM 800

       

      Now I have decide the Amount column as sales amount, Insurance amount  and Commisions Amount based on the combinations of A B C and PC.

       

      For example if A =1 B=2 C=3 and Code =PC then the Amount should be flagged as Sales amount.

                         if A=1 B=3  C=4 and Code=PM then the Amount should be flageed as Insurance amount.