DP1 contains equipments and escalation numbers. Every equipment has 1 or 2 escalation numbers.
DP2 contains equipments and service orders. Every equipment can have up to 30 service orders.
I want to to see all escalation numbers and related service orders in one table, so I link on equipment, which is working fine if there is only 1 escalation number on the equipment.
As soon as there are 2 escalation numbers on the equipment (so equipment is not unique), then it shows 1 service order for the 1st escalation number and all the other service orders of that equipment on the 2nd escalation.
Any idea how I can fix this to see all service orders of an equipment in relation to all escalations of that equipment ?
Note that RN01 and RN02 belong to both GROUP1 and GROUP2, and I think that is the special case which makes the trouble.
What I want is to calculate Number2/Capacity1 per Group_Name1 per Time2.
I link RN_Name1 with RN_Name2, and have 2 options:
if I declare Group_Name1 as dimension then Time2 is not possible to involve into calculation, because Group_Name1 is in the table
if I declare Group_Name1 as detail then it gives strange result as below (it is not possible to get accurate values for each Group_Name1 per Time2, since RN01 and RN02 are belonging to both GROUP1 and GROUP2)