4 Replies Latest reply on Oct 4, 2018 2:14 PM by Chris McClellan

    Problem in the calculated field in Tableau

    Ramesh Ravichandran

      Hi,

       

      Below is the data set. I would like to create the calculated field eg: Prior Month Amt which is value of the current month amt of next row.

       

      I have used the look up function but the problem is that when i use the filter for "Version" and select only one month i am gettting NULL value for the newly created Prior Month Amt column.

       

      Is there a way to create the calculated column which will not be affected by the filter or parameter for this scenario