Excel file carry two types under two rows

[nevilledhamsiri]

Dear Experts!

As per the two tables where one table carries recovery types under two rows(RECOVERY_BF) but the other file it is shown under two dimensions (CLRECBL & RFCBAL). When both files are loaded, when balances under both types appear, it is appeared twice. Can you please suggest as to how it could be made appear something like below! (Sample case)

Claim_no                    Recovery_type          Recovery_BF               CLRECBL               RFCBL

CLAS00TC17000001     Foreign_recovery     100500                         100500                    -

CLAS00TC17000001     Reinsurance Fund     6000                              -                         6000

If I am to show as above all cases where balances are appeared under both recovery types, what adjustment to be made!

Many Thanks

Neville

[sasiparupudi1 · Accepted solution]

Like Attached?

change the expression RECOVERY_BF

to IF(Aggr(Count(RECOVERY_TYP),CLAIM_NO)>1,Sum (RECOVERY_BF))

[nevilledhamsiri]

Thank a lot Sasidhar

Neville