It's Bit Confusing . Can you attach some mock up workbook to help you?
Thank you for the reply .
Currently my data is :-
Item_id lot_number region
6 32 South
7 23 North
7 43 South
5 56 South.
The result i want is :
Item_id Lot_number Region
7 23 north
I dont want to display item_id 6 and 5 here. Just 7
Sorry for the late reply.
It is still not working
What is not Working Vaibhav...Did you open attachment.
Let me give you a packaged workbook if possible
ok and please spell out clearly what is your requirement to help you.
Thank you Deepak .
The calculated fields are working correctly.
Custom SQL query did the trick.