4 Replies Latest reply on Feb 11, 2016 12:13 PM by Shinichiro Murakami

    Create drop down OR filter using multiple dimensions


      I want to create a multiple value drop down filter using specific data from 2 different dimensions.

      One dimension is a list of diagnosis codes 1-10 [dx cd].  I only need to see codes 1,2,3,4,5 from this list.  The other dimension is a list of procedure codes 20-30 [proc cd].  I only need to see codes 20,21,22 from this list.

      I want to combine all of the codes (1,2,3,4,5,20,21,22) in one drop down multiple value OR filter so it will display all of those diagnosis OR procedure codes.  Whatever I do only displays the diagnosis code if it matches one of the procedure codes (20,21,22) from the list and vice versa.

      Example: if I have code 1, the results could display procedure code 25 or if I have code 20 it could display results with a diagnosis code 10.