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
      box1
      pallet10
      truck100

       

      source shipped

      ship dateshippedqty
      11-11-2013box200
      12-11-2013pallet30
      13-11-2013truck5