3 Replies Latest reply on May 30, 2013 9:18 AM by Robin Kennedy

    Data blending

    philip ken

      I had created two connections (2 different table) to show data in one table.

      Connection 1 has Country (USA, CANADA) and Sales Revenue.

      Country     Sales Revenue

      USA            100K

      CANADA      200K

       

      Connection 2 has Country (CHINA, JAPAN) and Sales Revenue.

       

      Country        Sales Revenue

      CHINA           400K

      JAPAN           700K

       

      I want my report (table) supposed to be show as below format.

       

      County           Sales Revenue

      USA              100K

      CANADA        200K

      CHINA            400K

      JAPAN            700K

       

      Is this Possible?