7 Replies Latest reply on Oct 17, 2018 11:04 AM by Deepak Rai

    Date conversion Help??

    Emrick Altidor

      I am looking for a way to convert the date

      Where January = 12, Feb = 11, March = 10 and so on.
      I need to use is in the example below.

      the field names are for example

      Region, Month and Amount.

       

      I need to create a calculated field where each month will multiply with the number corresponding to the related month.

      for example Jan for region ABC has an amount of 541

       

      Calculated field X =  Amount x 12 where tableau determine the value of 12 based on the Month

       

       

      RegionJanFebMarAprMayJun
      ABC541123987147741159
      DEF125456654258852753
      GHI356789321369963591
      AnnualJanFebMarAprMayJun
      ABC=B2*12=C2*11=D2*10=E2*9=F2*8=G2*7
      DEF=B3*12=C3*11=D3*10=E3*9=F3*8=G3*7
      GHI=B4*12=C4*11=D4*10=E4*9=F4*8=G4*7