1 Reply Latest reply on Jun 17, 2016 12:21 PM by Tom W

    Filtering

    Morgan Strong

      Hi,

       

      Is there a way to customize filters such that the user has the capability to filter on columns and values?

       

      In this screenshot, I want to allow the users to choose "Profile Type", "Profile Tpye Other Des..." "Tax Payer ID Type" etc. and then choose the enumeration? I wanted to avoid having too many quick filters on my screen. Is this possible?

       

      Thanks!

      Morgan

        • 1. Re: Filtering
          Tom W

          If it's just FAIL/PASS combinations you're after, you could setup two parameters; one called 'Field' which has a list of the 'columns' in your report. The second could contain PASS, FAIL.

           

          Then create a calculated field to use as a filter;

          IF [parameter_Field] = 'Profile Type' and [Profile Type] = [parameter_passfail] then 'include'

          elseif [parameter_Field] = 'Tax Payer ID Type' and [Tax Payer ID Type] = [parameter_passfail] then 'include'

          .....

          ....

          else 'exclude

          end

           

          Then drag that calculated field onto the filter shelf, set it to include and you'll be all set.

          1 of 1 people found this helpful