4 Replies Latest reply on Sep 13, 2012 1:27 AM by Manish Baheti

    Linking Data across two sources

    Manish Baheti

      I have two data tables:

       

      A) Fields (Item Name, Brand Name, Avg. Sales, Avg. Inventory, DOH etc.) -- About 500 line items (each lineis unique with Item Name as identifier)

       

      B) Fields (Item Name, Period, Forecast ($), Forecast (#)) --- About 6000 line items (each line is unique with a combination of Item Name + Period There are 12 periods (Jan-Dec) for each Item Name)

       

      Task: I would like to calculate a field of "Target" by using Item Name, Period, Forecast (#) from Table B and multiplying forecast by DOH (from Table A) to display that as bar chart subsequently using roll up options from Table A fields (Brand, Category etc.)

       

      However, I am unable to link the two tables in Tableau.

       

      Let me know if there is any way around this.

       

      Regards,

      Manish