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



      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?