Skip to Content
0
Former Member
Feb 27, 2009 at 09:15 AM

FOX formula help required

30 Views

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