4 Replies Latest reply on Nov 6, 2013 8:14 AM by Jason Back

    Calculation between two data sources and aggregating calcuation

    Jason Back

      Hello fellow Tableau users,

       

      I am doing a currency exchange calculation using two data sources; one has local currency and the other has exchange rates to USD.

       

      I've managed to calculate everything to USD but if I change my view level to higher view the calculated US dollars won't aggregate.

       

      I've attached the example. Here, if I remove "Store" from rows I cannot see the total of US dollars by regions.

       

      Any solutions would be much appreciate! Thank you!

       

      Jason