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