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.
5 answers
Attached is an example from a workbook I just created, this could be manipulated depending on what you want to show.
