Forum Discussion

Umadhandapani's avatar
Umadhandapani
Icon for Helper II rankHelper II
4 years ago

Row and Column Header doesn't match, due to indirect relationship

Expected: Hi, The above is the sample format of the report. I have taken Organisation from two different tables, but they're having indirect relationship (no direct relationship). I have ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Umadhandapani , best to have two independent dimensions and create measure based on those with these values .

 

Or join with dim to the org column of both tables