3 Replies Latest reply on Sep 12, 2013 8:11 AM by Alex Kerin

    How to do particular caculation which traditionally can be done by for loop???

    s.s

      Hi ALl,

       

      New to Tableau .

       

      I am joining two spread sheets test and test2. I have attached two spread sheets below.

       

      Join is on Company and state.

       

      What I need to do is create calculated field which will check below condition and get corresponding value of percentage column from test2:

       

      If month and year of (From Date) from test spread sheet = month and year of (date) from test2 then

       

      Corresponding Percentage from the row of test2 spread sheet

       

      Else

       

      Percentage from the row of maximum of date from test2 spread sheet.