I'm having grouping dimensions differ from country to country,after that creating separate table for each country based on their grouping.
I related all these tables to the main Fact table.
Now i'm having a column ABC in grouped table where the the data in it is A,B,C.And A,B,C are calulated based on some conditions.
Now I want ABC column from Grouped Country table data when I select particular country.
I'm attaching Image for reference. Accepted-UK,Accepted-USA,Accepted-Germany,Accepted-Canada are grouped tales based on dimensions for each contry.If I select UK country I want to get ABC column from Accepted-UK,If I select Canada country I want to get ABC column from Accepted Canada. How to do that?