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:

       

      data_model.jpg

       

      Now I am facing some difficulties building a table like:

      table.jpg

       

      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