Welcome to the new CogKnowHow.com!


If you have trouble logging in, reset your password via the login window
by clicking the 'Forgot Password' link.

Pick up the initial value for every row of a crosstab


#1

Hi all,
I have a requirement in which i have to pick up the initial value of each row in a crosstab…
My crosstab looks like this

value 1960 1970 2010 2011
aus 10 5 11 6
eng 5 2
bra 11 4
ind 8 11

i have to add another column which picks up the initial value for every row based on the year…
so the result should look like this.

value 1960 1970 2010 2011 initialValue
aus 10 5 11 6 10
eng 5 2 5
bra 11 4 11
ind 8 11 8