0 Replies Latest reply on Sep 18, 2013 11:27 AM by Kayla Sather

    Sum two worksheets with different dimensions

    Kayla Sather

      I am brand new to Tableau and this is my first question for the forum. I am grateful for this tool.

       

      I have two different worksheets and I need a Sum by region, territory, and product.

      Ex:
      ProductTheaterRegionPrevious 12 monthsRecent 12 months
      Product 1APACJAPAN$987,164$678,933
      Product 2APACJAPAN$1,208,421$935,418

       

      In excel I concatenate region/territory/product and use a vlookup to add the two pivot tables together. I can't figure out how to do this in Tableau. I need some help thinking outside the box. I attached a picture. Thank you!

       

      Jans Report.jpg