Tableau If value is null then use previous value (PREVIOUS_VALUE) Create a calculated field which does the null check on the field and t o get the value from the previous cell, you'll have to use a tableau calculations as shown below . PREVIOUS_VALUE(expression) Returns the value of this calculation in the previous row. Returns the given expression if the current row is the first row of the partition. Example ifnull((sum([Direct Costs])), PREVIOUS_VALUE(sum([Direct Costs]))) SUM([Profit]) * PREVIOUS_VALUE(1) computes the running product of SUM(Profit)