6 Replies Latest reply: Feb 14, 2014 10:22 PM by Srikanth P RSS

    Combine data of two tables

      Dear all,

       

      I have a table with the average revenue per user per year per insert year (year of registration):

      InsertYear

      Year

      2009

      2010

      2011

      2012

      2009

      -

      € 8,99

      € 20,02

      € 21,68

      € 21,34

      2010

      -

      -

      € 11,00

      € 20,13

      € 20,78

      2011

      -

      -

      -

      € 7,98

      € 21,47

      2012

      -

      -

      -

      -

      € 8,52

      Totaal

      -

      € 8,99

      € 11,98

      € 10,63

      € 13,18

       

      And a table with the retention costs per user per year per insert year (year of registration)::

      InsertYearCosts

      YearCosts

      2009

      2010

      2011

      2012

      2009

      -

      € 2,00

      € 1,50

      € 1,00

      € 0,50

      2010

      -

      -

      € 2,00

      € 1,50

      € 1,00

      2011

      -

      -

      -

      € 2,00

      € 1,50

      2012

      -

      -

      -

      -

      € 2,00

       

      The names of the year fields differ per table:

      Year = YearCosts

      InsertYear = InsertYearCosts

      Because of the different names, I cannot do calculations on both. I would like to deduct the retention costs from the average revenue per user and display the results in a new table.

       

      I tried to amend the load statement to set the names the same, But then I get an error. I researched set analysis and variables but it didn't get me any further.

       

      Does anybody have a solution? All help is appreciated.

       

      Best regards,

      Dorine