Hierarchy Per Unit Calculation

Question

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 and B

at the top level i want to see the total for Name 2 for example C would be sum(ValueAmt) / 100

then the next level down have sum(ValueAmt) / 40 for Name 1 = A and sum(ValueAmt) / 60 for Name 1 = B

Below is tables as an example what I am trying to do.

Table A is Dollar Data information. Table B is units.

Report is want I am trying to get to where [+] is going to go to the next level down

v-yuta-msft · Answer

HI&nbsp;homer4184,
&nbsp;
You can create hierarchy based on Name2 and you can also use a matrix and drag Name2 and Name1 to column field.
&nbsp;
Regards,
Jimmy Tao

homer4184 · Answer

I get the hierarchy portion of it, the problem I am facing is the calculation of the Value&nbsp;Heres a better repsentation of the final result&nbsp;C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sub Total C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; R&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sub Total D75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;60&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22

Forum Discussion

Hierarchy Per Unit Calculation

2 Replies

Related content

Calculation groups & Column Hierarchy

Date hierarchy

Dynamic Y range visual calculation in two level hierarchy

Unit testing in report

Understanding Capacity Units (CU)