As we cannot use context filters for secondary dimensions, how can we achieve the same functionality using calculations/parameters etc ?
e.g. DataSet1 contains details - empID, experience, level, designation, unit, department etc.
DataSet2 contains details - empID, country, state, city.
Both the data sets are blended using empID field. I have drawn a bar chart from DataSet1 and want to put 3 filters from DataSet2 (country, state, city) on the same bar chart such that the 2nd filters shows related data as per selection made in filter 1 and same for filter 3 as per selection made in filter 2.