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!
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
I can't quite figure out your data, but is there a possibility to use Linked hierarchies in BW to match your result?
Koen,
Thank you for your input;unfortunatley, I am on BPC Optimize , so all hierachey debited from S/4HANA.
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!