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?