This is how my data looks like:
|1||1||greater than 2||M||East||Analyst|
|2||0||less than 2||F||South||Manager|
|3||0||greater than 2||F||South||Analyst|
|4||0||less than 2||F||North||Manager|
|5||1||less than 2||M||West||Consultant|
|6||1||greater than 2||F||East||Consultant|
|7||0||less than 2||M||East||Consultant|
|8||0||less than 2||M||West||Manager|
|9||1||greater than 2||M||North||Analyst|
|10||0||greater than 2||M||North||Analyst|
1: Have created a combo chart representing bar graph for count of attributes and a line chart for attrition based on flag var.
2 :Created basic filter based on different dimension available in the data as when gender male is selected user can see attrition and count of attributes for male category .
3: Now I want to create a drop down list of dimension in this case gender region and level such that if a user now selects level, he would see three dual axis charts each for analyst,consultant and manager for male selected in step 2 to compare.
I have been successful till creating drop down list of dimensions,have tried alt view and cyclic dimension extension .
My question is how could I achieve step 3.