1 Reply Latest reply on Aug 12, 2016 2:42 AM by pulkit jain

    How to hide value in filter?

    Koti D

      Hi all,

       

      i have a filter called country

      ex:

      country

      india

      us

      aus

      sa

       

      i dont want to show the india value in filter? but i want to show the india related data in the sheet.just name i want to hide not the data which is related to india?

       

      how to achive this?

       

      thanks,

      koti.

        • 1. Re: How to hide value in filter?
          pulkit jain

          If you have fixed set of countries then you can create a parameter of country names.

          then use this parameter in calculated field as

           

          if parameter= [country] or [country] = 'India' then 'true' else 'false' end

           

          use this calculation as filter in your report to include only true values.

           

          this method will only work as single select.

           

          If anyone have other method which supports multi select as well please let me know.