Forum Discussion

homer4184's avatar
homer4184
Advocate I
8 years ago

Hierarchy Per Unit Calculation

I am trying to do a hierarchy per unit calculation for 1 to many relationship tables.  Name 2 is a hierarchy level where Name 1 is the low level of 2      so when Name 2 = C that means Name 1 = A a...
v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

HI homer4184,

 

You can create hierarchy based on Name2 and you can also use a matrix and drag Name2 and Name1 to column field.

 

Regards,

Jimmy Tao

  • homer4184's avatar
    homer4184
    Advocate I
    8 years ago

    I get the hierarchy portion of it, the problem I am facing is the calculation of the Value

     

    Heres a better repsentation of the final result

     

    C                                                           D

    A          B             Sub Total C              R                          Sub Total D

    75         50           60                            22                         22