Data Relationships

Hello,

I have the following tables:

1. CC_Master (Includes unique cost center records columns - Cost_Center (numeric), and TM1_CC_Lookup (AlphaNum)

2. FIT table (transaction table), which includes Cost_center column and mapped to CC_Master on many to one. Cost_center column of FIT table connects to TM1_CC_Lookup column in CC_master & direction is single 

3. SAP table (transaction table), which includes Cost_center column mapped to CC_Master on many to one, single direction. Cost Center column of SAP connects to Cost_Center column of CC_Master.

On my report, i have one matrix table getting data from FIT table, which includes Date, Cost center, currency, cost element, country etc., & on another table, i have SAP data.

When i apply filters from other organization values (country, Cost center, currency etc.,), and select cost element from FIT table, the corresponding SAP table filters data only to Cost Center, but not at the level of Cost element

Pasted below is my data

Appreciate if anyone could help me please.

Regards

Sai.