Show All Subsidiaries of an Account on One Row

Scenario: In an Account Search, Subsidiary added as column with Group as Summary Type. The same Subsidiaries appear on different rows, it seems like they are not being grouped together.

Solution

1. On the Search, click Edit this Search
2. On the Results tab,
   • Field: Select Formula (Text)
   • Summary Type: Select Maximum
   • Formula: Enter ns_concat({subsidiarynohierarchy})
3. Click Save & Run