KB15742: How to create a joint element list filter in order to choose different criteria for two different attributes in MicroStrategy Developer 9.4.x - 10.x

If a user creates a report with two attributes, for example Country and Warehouse, the user may want to create a joint element list filter in order to choose different criteria between the attribute elements. To do this, follow the steps below:

• Create a new filter.
• Select 'Advanced Qualification', as shown below:
  

• Select Joint Element List from the drop down list, as shown below:
  

• Add the two related attributes (Country and Call Center), as shown below:
  

• Pair both attributes with their corresponding element(s).

A second option would be to create a custom group, but take into consideration that it would create a larger amount of SQL passes at run time, making it less efficient than the joint element list filter.