5 Replies Latest reply on Mar 30, 2016 5:05 AM by Phil King

    Recursive Lookup for Comparison

    Phil King

      I need to create trend data by comparing prior weeks data vs the current week and present them side by side in a table.  The idea being to add a value column for the same project/prior week date, same project/2 weeks prior... etc..  I've been able to create a similar approach using other tools with a lookup function based on a compound key with ID/Date values.  Any suggestions on how to invoke a lookup on calculated field values instead of relative row and column position?  I'd like to return a value from a column of earlier dated records to calculated columns in the current record.

       

      Thank you.