ORG Chnl HiId Cat GBB MC SBU SubCat PRCLVL Var Yr Growth
HKB1 RE H1 - - - H115 - - Z1 2009 43.0
HKB1 RE H1 - - - H114 - - Z1 2009 31.0
HKB1 RE H1 - - - H113 - - Z1 2009 54.0
HKB1 RE H1 - - - H110 - - Z1 2009 67.0
HKB1 RE H1 H11002 H1GD10020402 H110020402 H110 H1100202 FULL PRICE Z1 2009 0
HKB1 RE H1 H11002 H1GD10020402 H110020402 H110 H1100202 FULL PRICE Z1 2009 0
Hi All,
This is the structure of my plan cube, my requirement is to copy the value of growth (67.0) from Line item 4 to last two rows since SBU of row 4 is = SBU of row 5and 6.
Basically I want to copy the growth factor corresponding to row 4 into all rows with same SBU i.e (H110).
Pls suggest some FOX formula.
Regards
Amit Jain
9717069090