Displaying results in Bex Division wise. Multiple nodes for a division
I have a hierarchy built on 0PROFIT_CTR InfoObject. This hierarchy has like 9-10 levels. and lets call the bottom most nodes as Profit Centers ( Ex 100051 : Breeeder Farm, 100020: something )
Now business has defined some divisions, which basically consists of some of the above said profit centers.
For Example : PXS Division has 100051, 100020 , some more as its profit centers.
and the name of Node 3 Levels above the bottom most level has the same Name, what we want to display in the Report.
The format required is somethin like this
DIVISION PROFIT CENTER AMOUNT (KF)
PXS 100051 X USD
PXS 100020 Y USD
PXS 100091 Z USD
PYS 100001 * USD
PYS 100008 * USD
assuming 100001 and 100008 belongs to division PXS
I am not able to create the first two columns frm the same Characteristic ( OPROFIT_CTR).
any kind of help would be rewarded by points