8 Replies Latest reply: Mar 13, 2018 10:57 AM by Nayan Lalla RSS

    How to combine different dimension in an object

    Nayan Lalla

      Hi

       

      For simplicity, I have the 2 tables below in my front end (Table1 & Table 2).  The one is Sales by Manager whereas the other is Survey Count by Survey Manager.  The values in the Manager and Sales Manager fields are the same person. I want to create a table in the front end where Manager and Survey Manager are linked. (see below table Correct).

      However, my table is not displaying correct (see table marked Incorrect)


      Please note, I don't want to link it in the backend as it has implications on other parts of the model.

      So, can this be solved in the frontend only.


      Your assistance is appreciated.

       

      Kind regards

      Nayan

       

      Table 1

       

      ManagerSales
      A20
      B30
      C60

       

        Table 2

      Survey ManagerSurvey Count
      A6
      B10
      C15

       

      Correct

       

      Sales ManagerSales Manager SurveySalesSurvey Count
      AA206
      BB3010
      CC6015

       

      Incorrect

       

      Sales ManagerSales Manager SurveySalesSurvey Count
      AA206
      AB2010
      AC2015
      BA306
      BB3010
      BC3015
      CA606
      CB6010
      CC6015