I have 10 tables and all are connected with single con_id and have 4 filters which I am getting from one of the tables (table_1) as it has all master values required for filters. There are different tables for different KPIs.
Now issues is, there is 1 filter LOCATION which is not getting applied on one of the KPIs (table_2) which is connected with table_1 with con_id. Issue I have observed is, for 2 locations table has samecon_ids.
How I can resolve this issue, I tried synthetic of con_id and location, but not working.
