2 Replies Latest reply: May 15, 2013 1:54 PM by João Almeida RSS

    Source and Destination Movement

      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,