Any other work around on my concern..please!
Rephrasing the issue with Global Store data.
When any of the field is selected from sheet1, it has to drive the Sheet2 & Sheet3.
When any value from Sheet 2 is selected, it has to drive sheet3.(it works when i place ID field in detail of sheet2, but i get all ID's in the bar which i don't want as shown)
1. Sheet1 & 2 are driving from one data source and sheet 3 is from other DS.
2. Sheet 2 measures are calculated on the fly.
I was not able to drive the sheet3 when sheet2 was selected.
Hope it is clear...
any suggestion are highly appreciated!
It's urgent.. please help in resolving this issue.
I think tried all possible ways, but no luck... and am helpless on this issue.. and seeking help from you guys on the same.
Have a great Day!