Create a BEX Report to populate a new Field

Hi All,

I have a requirement of creating a Bex Report in which there will four variable prompt - 2 on 0VENDOR ( say Vendor1 and Vendor2 )and 2 on 0VENDOR-DUNS Number. The client want the report should display 'Complaint' to be displayed in a new field at the report level if they have pass value to 'VENDOR1' variable and 'Non Complaint' value in the New field if they pass vendor value to 'VENDOR2' variable.

Similarly for other two variables.

Kindly suggest, I am need of very urgent deliverable timeline.

Thanks,

Ranjan