URGENT: using the row value for getting column value.

[#1]

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.

[Former Member]

HI,

Use Formula Variable with replacement path to get row values to coloum Values.

If it dosent help, explain the scneario in detail.

Best Regards,

Meiy

[Former Member]

Im new to BEx so i dont know how to use formula variable with replacement path. Will u plss explain the procedure????

[Former Member]

Hai

check this link how to create formula variable

http://www.sd-solutions.com/documents/SDS_BW_Replacement%20Path%20Variables.html

i dont know whether this is the solution for ur question but if u explain bit more about the problem that would help us to solve

regards

abi ram

[Former Member]

hi.....could u send me any document which will elaborate more on replacement path & how can i select the row value to get column value.......