Source and Destination Movement

[#1]

Hi community!!!!

Considering that I have to model movements between two Factories and that each Factory can be the source or destination of the movements, I built the following model, using a Link table that indentifies the Source and Destination of the Movement:

Now I am facing some difficulties building a table like:

I am using a Pivot Tabble with two dimensions and one expression:

1. Destination - Calculated dimension using: if ( MovType = 'Destination', Name )

2. Value - sum (value)

The question is how do build the second dimension (Source) using a calculated expression, because I have the Souce Factory name in the same table as Destination Factory?

Many thanks,

João

[jvitantonio]

Hi, please check the file attached.

[#3]

Hello qlikuser14,

Thanks for your reply. Unfortunately the example you sent does not answer our problem. We need to generate a table similar to what we posted initially, a column for Destination and another one for the Source that adds all the values between them (the aggregate value). Thanks again !