3 Replies Latest reply on Jul 15, 2014 7:13 PM by alisa.mendelsohn.1

    Create Custom Summary of Applied Filters

    Kevin Footer

      Hi,

      I have a group of users that would like a lot of options regarding the items filtered.  I want to create a summary of the filters that have been applied.  I can do this in the title, however, because of the long list of possible options, the filter summary just takes up too much space if you add everyone of available options.


      What I would like to do is add a formula that will hide the text if none of the items are filtered.


      Attached is an example of what I have currently.  In this example, I would like to only show Category, Region, or Segment if something has been filtered. Otherwise these should be hidden and under the filter summary there should just be some formatted text that says "None".


      Is this possible?

       

      Thanks,
      Kevin