Forum Discussion
Helper INeed help with relationship between two tables
Hi Everyone,
Thanks so much for your replies.
I found the solution to my problem and here is what i did.
I created a bridge table between these two tables and added al lth eunique cost centres there and then indivisually joined tables by oneto many relationship as
Table A many to one relation with Bridge table and Table B many to one relation with Table A and make it active and also filter direction to be selected as both.
Then createe 2 measures in the table 2 where i wanted to have the logic updated
Following all these steps my issue gor resolved.
Helper IHello Ryan,
thanks for your message.
PFB data for reference
| Table A | Table B | Table B | Table B | Table A | Table A | Table A | Table B |
| Year-Quarter | LB | CC | FC | Cat | Subcat | Amount | Act% |
| 2024-Q1 | NonCore | 100000 | 0000-AA000 | Compensation | Bonus | 7.284 | 99.6 |
| 2024-Q1 | NonCore | 100000 | 0000-AA000 | Compensation | Other Benefits | 13.7054 | 99.6 |
| 2024-Q1 | NonCore | 100000 | 0000-AA000 | Compensation | Pension Expense | 5.70776 | 99.6 |
2024-Q1 | NonCore | 100000 | 1111-AA1111 | Invest Exp | Invest Exp | -31.39126 | 0.4 |
| 2024-Q1 | NonCore | 100000 | 1111-AA1111 | Compensation | Bonus | 7.284 | 0.4 |
| 2024-Q1 | NonCore | 100000 | 1111-AA1111 | Compensation | Other Benefits | 13.7054 | 0.4 |
| 2024-Q1 | NonCore | 100000 | 1111-AA1111 | Compensation | Pension Expense | 5.70776 | 0.4 |
I have highlighted the columns to identify which is coming from table A and B. Many to many relation is created between these two tables and this is what i see in my report visual right now.
Now i want to create two logics, i.e. if the cat is Invest Exp then Act% should be 100 else as it is and Fc should be AA1010 else as it is. so expected result should be as below :
How can i achieve it.
Note: @ different tables.. Joined based on mamuy to many relation
| Table A | Table B | Table B | Table B | Table A | Table A | Table A | Table B |
| Year-Quarter | LB | CC | FC | Cat | Subcat | Amount | Act% |
| 2024-Q1 | NonCore | 100000 | 0000-AA000 | Compensation | Bonus | 7.284 | 99.6 |
| 2024-Q1 | NonCore | 100000 | 0000-AA000 | Compensation | Other Benefits | 13.7054 | 99.6 |
| 2024-Q1 | NonCore | 100000 | 0000-AA000 | Compensation | Pension Expense | 5.70776 | 99.6 |
| 2024-Q1 | NonCore | 100000 | 1111-AA1010 | Invest Exp | Invest Exp | -31.39126 | 100 |
| 2024-Q1 | NonCore | 100000 | 1111-AA1111 | Compensation | Bonus | 7.284 | 0.4 |
| 2024-Q1 | NonCore | 100000 | 1111-AA1111 | Compensation | Other Benefits | 13.7054 | 0.4 |
| 2024-Q1 | NonCore | 100000 | 1111-AA1111 | Compensation | Pension Expense | 5.70776 | 0.4 |