I have parent and child accounts that make a family. If the Parent_acct = Accnt_no then its parent account and others are child account. Associated with it is the Fee and Internal_acct_no for each account. The problem is how to concatenate the Fee in the family (same Parent_acct_no make a family) with "," ordering the result in ascending order of Internal_acct_no in the family.
I know I can use excel array function and do aggregation in the family. I have tried incorporating the 'Small' function in the array function to put the Internal_acct_no in ascending order and then concatenating, but it did not work.
Please see the attached file.
Bookmarks