do you think branches will continue changing their names?
If this is only an exception, you can simply group members, in order to have an unique alias (as you desire) and a sum of the amounts.
Actually there are lots of region and every region has lots of branch and they can change their name any time. It can be difficult to control group names.
I tried using a LOD expression in the formula that defines the Branch Name.
Please open the attached workbook and use that formula with your complete data, I don't know if it could work, let's try!
Hope it can help!
name.twbx 14.2 KB