How can you set up BEx Query with special Calculation refering Colum in the row above and below

[Former Member]

Hello Expert, I have a requirement where I need to set up a special Query. I wonder if anyone have worked in such requirement. I need to create a column with some X value calculation where I need to refer to different row and Column has show below

ColumnA = 100 ColumnB = 200 ColumnC = 300 in row 1 I need BEX to calculated X1 in row 2 and X2 in row 3 according to the formula below and considering row 1

in raw 2 and 3 ColumnA ColumnB ColumnC 100/200/300 and X1/500/600/ and X2/800/900

X1= 100-500 + 300 = 100

X2 = X1- 800+ 600

Anyone know how I can make this calculation from Bex Query ??? Of course, if all the input data was in the same row that will be a easy calculation but in this case, I have to refer to cells on row above .

Any input would be appreciate.

Thanks!

[kohesco]

I can't quite figure out your data, but is there a possibility to use Linked hierarchies in BW to match your result?

[Former Member]

Koen,

Thank you for your input;unfortunatley, I am on BPC Optimize , so all hierachey debited from S/4HANA.

[Former Member]

Hello Matthias,

I really appreciate your input;unfortunatly, I have tried that soluation. I cannot create cell references on 300 GL accounts. Also, there is an hierachy which I would like to keep dynamic.

Please let me know your thoughts

Thanks!

[former_member457111]

Create two structures and the tab cells appears when you can define each cell seperately. With reference cells you can use each cell for your calculations