1 Reply Latest reply on Jan 14, 2014 11:44 AM by Tracy Rodgers

    calculations with 2 data sources

    Bas Custers

      Hi all,


      I' a beginner with Tableau and I'm trying to figure out how I want to present my calculations. in sheet 1 I have my numbers of boxes shipped and in another file I'll have my pricing figures (like box tariff, pallet tariff). Both files are not equal so I want to create a calculated field which will add a variable in sheet one which will tell me if the line holds a box or a pallet and use this variable to get the correct price from the other table.


      What can be the best way to get this into 1 source or how can I create the link between the files?


      Thanks in advance!


      source tariff

      tariff typetariff


      source shipped

      ship dateshippedqty