2 Replies Latest reply on Oct 10, 2016 3:43 PM by Derek Wong

    Converting currency values using exchange rates in a different table

    Ram Atmakuri

      Hello Friends,

       

      I am new to Tableau and trying to build a custom report for my business. I have a report in the below format and there are thousands of lines in various currencies. All this information is coming from one source

       

      Conv.JPG

      and there is a different table from where the daily conversion rates are coming. which is as below. I am looking for help on how to link up these two so that I can convert the non USD balances using the conversion rates below to USD balance?

       

      I tried adding this table as a secondary source, but then how do I

       

      • Link both tables?
      • How do I filter the conversion date as the today?
      • how do I lookup for the specific currency and the related value?

      Rates.JPG