6 Replies Latest reply: Mar 31, 2014 10:14 PM by ben lim RSS

    Urgent, with attached file. On pivot table.

    ben lim

      Hi all, see attached more clarity.

       

      firstly do check on the table layout on how it is jointed.

       

      I have two table of data name Throughput and TXIT.

       

      I would like to find the value (TEU) of Country (Country_Code) for tput and transit

       

      As you can see on table name : Throughput and Transit, the fields are basically matching to each other when i use Country Code and TXIT_Country_Code.

       

      However, my problem is I would like to combine this two onto one table (Table : Input code here)

       

      Can i do it on Dimension to make both of them join together? Since it carries the same meaning

       

      Thanks!