Show unrelated values in one row

[muhammadraza]

Hello guys,

I have the following

Actually I want to display the last column value (Amount at RIM Level) on the basis of RIM column (not on the basis of account number) (as shown), please guide how can I achieve that thing. PFA is the source excel sheet and qvw file.

Best Regards,

Muhammad Raza

[MK_QSL]

What is your output table looks like?

[Anonymous · Accepted solution]

Hello, Muhammad.

You can solve your prmblem in the script. Please take a look at the attached qvw.

Hope it helps.

[muhammadraza]

the table indicated with the down arrow.

[MK_QSL]

Don't understood the logic of last column