1 Reply Latest reply on Aug 8, 2016 9:56 AM by Mike Burke

    Need help to create calculated field with fixed and changing value

    Claire Besson

      Hello,

      I am new in Tableau and I would need help for a calculation.

      I have two sheets with data as showed below:

      First Sheet

      Country

      Value

      Date

      Canada

      123

      2016-02-01

      Canada

      456

      2016-03-01

      Canada

      376

      2016-04-01

      USA

      456

      2016-02-01

      USA

      376

      2016-03-01

       

      Second Sheet

      Counter

      Value

      Date

      X1

      1

      2016-02-01

      X1

      1,2

      2016-03-01

       

      I would like to do this calculation:

      For each country: calculate X1 value of February x Canada value of February. (1 x 123)

      For each country: calculate X1 value of March x Canada value of February. (1,2 x 123)

       

      Basically the Canada value is fixed (value of February). I would like to do this for each country.

      Could you please help me with that?