please help me

[#1]

My data is like this

No           ExtendNo         Prd                    amount

1011           00                    API                       2500

1011           01                    AMK                       0

1021            00                     AKC                      5000

1021            01                      AMK                      0

1031           00                       KPI                      6000

1031           01                        AMK                    0

PLEASE HELP ME .

MY OUTPUT IS LIKE THIS

IF I SELECT  ONE FLAG EXAMPLE(A&B)

I SELECT FLAG A:  MY OUTPUT IS SAME AS ABOVE 

IF I SELECT 'B' : MY OUT PUT IS LIKE BELOW

NO           EXTENDNO           PRD             AMOUNT

1011               01                     AMK                2500

1021                01                      AMK                 5000

1031                  01                    AMK                   6000

THIS IS MY REQUIREMENT PLEASE HELP ME IT IS POSSIBLE OR NOT

THANKS IN ADVVANCE

REGARDS

ANANTH

[#2]

Can you also disclose the flag field in this data?

[#3]

Hi Ananth:

Check the attached App, hope it helps...

Thanks,

Narasimha K