Forum Discussion
Helper VDrillthrough is not working correctly
It works as expected based on the active relationship. I believe you are trying to include the Problemcode as well in the active relationship.
Create a new key column in both the tables as below..
Simply, you could join the tables based on the new column to achieve what you need.
Or
you have to build a new dimension for Serial and ProblemCode as below and use that to define relationships
Serial ProblemCode Key
A A AA A B AB B C BC A A B B Note that I have removed Serial and ProblemCode from other two tables.
The graph in the overview page and drillthrough filter will use Problemcode from the new table.
If it helps, mark it as a solution
Kudos are nice too
Helper V- VasTg
Memorable Member
It works as expected based on the active relationship. I believe you are trying to include the Problemcode as well in the active relationship.
Create a new key column in both the tables as below..
Simply, you could join the tables based on the new column to achieve what you need.
Or
you have to build a new dimension for Serial and ProblemCode as below and use that to define relationships
Serial ProblemCode Key
A A AA A B AB B C BC A A B B Note that I have removed Serial and ProblemCode from other two tables.
The graph in the overview page and drillthrough filter will use Problemcode from the new table.
If it helps, mark it as a solution
Kudos are nice too