Hi All ,
I have two crosstab report on same page. Source for these crosstab is different.Refer to screenshot attached.
Each crosstab contains a country column (added as column).
Now i want to establish relationship between these two crosstab such that whatever countries are appearing in crosstab1 ,same should appear in crosstab2. Some how wanted to establish relationship between crosstab based on country.
Is it possible. I got to know using master detail relationship i can achieve that. But i do not know how.
Please advice/suggest ways to achieve same.Thanks!
That doesn't sound like a master / detail situation... I would suggest you need to identify the primary data source for your countries, then build outer joins to the measures tables
I am guessing that what you want is the same list of countries as your columns. Assuming a relational package, as BigChris said the Framework Manager model needs to set the relationships as outer joins. Otherwise, you are only going to get countries that have associated data.
The master/detail was probably suggested having a country query as the master and each crosstab as details. That is not really going to fix the issue at all.