cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible to refer one table to another two?

former_member699135
Discoverer
0 Kudos

Hello!

Im having problems creating some report in Webi, this is the example:

I need the blue columns show me the balances from Partner Company Code, and as it is a table, all the amounts that it showed there are with reference as the first column "Consol Company Code"

is there a formula that I can use to give me the info for second column?

I also try to combine two tables:

But I don't know how to combine them in a thrid one to have similar format like in the first image.

I hope somebody can help me on this!

Thanks in advance.

ayman_salem
Active Contributor

Where are the images?

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member699135
Discoverer
0 Kudos

Sorry the pictures weren't uploaded correctly, Please find the examples below: