Dear all,
I have problem with my set analysis. I want to aggregate without NULL value. like my example
| Account | Client | Type |
| A111 | A111 | S |
| T111 | A111 | K |
Each client will has 2 Accounts. and I want to display same a TYPE based on a TYPE of row ACCOUNT=CLIENT. It means , this is what I want:
| Account | Client | Type |
| A111 | A111 | S |
| T111 | A111 | S |
I'm using set analysis: aggr(nodistinct if(Account=Client,Type), Client)). But it not works
If you have any solution, please comment for me. Thanks a lot
Cheers,
