URGENT: using the row value for getting column value.
hi......i want to use the row value for getting the column value. ie.
if in the row the year value is 2007 & i said that i want (year in the row) - 1. then in the column value should pick 2006.
if the year is 2008 then column value should be 2007.
how can i read the row value ? pls help.