How to display previous year compa-ratio

Summary:

Content (required):

Hi,

We are trying to include last year's compa-ratio in our next compensation cycle. Our worksheet shows current and new compa-ratio. Are there any ways to create a column to display previous year/historical compa-ratio?

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):