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???


      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




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