One of those annoying super simple but not problems lol. I have an employee search that contains SSN# for our HR Manager, this is giving multiple lines based on multiple addresses the an employee has (yes we need to see the address primarily the shipping add.) I can't group the extra addresses out because the SSN# doesn't allow grouping. I can't reference the SSN# in a formula field because NetSuite is stubborn. The Address : Default Shipping Address criteria and Filter don't like me. I've been working on a criteria formula to only show the highest internal ID of the addresses but it doesn't like me thus far. EDIT: Figured it out, used a formula in the results column for each address point like:

CASE WHEN {address.internalid} = {address.internalid} THEN {address.state} ELSE NULL END