User defined function

  • Thread starter Thread starter Carlos Paez
  • Start date Start date
C

Carlos Paez

I am searching for a User defined function that works in Hierarquical
structures.

Hierarquical structures contents elements at a level (father) that are
divided in different elements at the next level (sons). The Work Break
Down Structure used in Project management is one of them, usually each
element has a identifying code like this:



CODE MH

1

1.1

1.1.1 30

1.1.1.1 10

1.1.1.2 20

1.1.2

1.1.3

1.2

1.3

1.4





If an element has an assigned value (for example man hours MH), the "father"
has value of the summation of its "sons" (30=10+20). Calculation is made
this way up to the top of the structure.



Is it possible to develop a function to calculate the sum of the variable
(MH) at any level? (provided that values at the lowest level are known)
 
Carlos,

The Pivot Table will give you group totals. It won't put them into your
existing structure.
 
Back
Top