Hi Jonathan and Manish,
The solution you suggested is not working correctly.
Actually I have another entries in Region like EMEA and other entries in BU Unit like PPS Commercial , I need that fields to be retained
Actually I got the solution but I am not understanding how it is working .How not equal to is working when we use OR and AND functions. I have also thought or done like you both before but it is not giving the expected result.
For your reference I am attaching the qvw with answer.
Test1223446.qvw 146.5 K