Reporting on catalog variables - How to filter by variable answer

[JC S_]

We have setup a catalog item with several variables. Now when setting up reports for this catalog item, we need to filter for example by the answers on the variables.

For example, we have below variables and choices:

1. Department
2. • Dept A
   • Dept B
   • Dept C
3. Order type
4. • Type X
   • Type Y
   • Type Z

Our report requirement is to see requests with Department value as "Dept A" and Order Type value as "Type X". How can we setup this report?

[Slawek_Radziewi]

I suggest using variables table to prepare such reports and filter by question and answer. 

Table: sc_item_option_mtom

[JC S_]

Problem is if we need to report on multiple variables at once and want to pull-out the details of that request. Is there any straight-forward way to report as-if they all exist in one table. We can already pull-out the columns from the variables currently and just need to filter them in the system instead of downloading and filtering on a spreadsheet.