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!