Hi All, I have saved search of Account type in UI with few fields, if I don't include subsidiary the result is getting well if I include subsidiary field and for some of the result rows having subsidiary as parent due to this duplicates occurring with child subsidiaries, how can I stop occurring duplicates with child subsidiaries. Your help will be appreciated.

what you could do is do summary results and group by account. If you want to show all subsidiaries in one row you can have a column “Formula (Text)” with a minimize/or maximize (doesn’t matter) and then use the formula “NS_CONCAT({subsidiary})” change subsidiary if I got the field id wrong. This function is undocumented but has worked for years.