1 Reply Latest reply on Sep 17, 2018 2:09 PM by Joe Oppelt

    Wildcard Match for Action Filters

    Franco Verri

      Hi, I'm working in a report with action filters to move between sheets. I want the user to be able to clear the filters in the sheet it's moving to, so I want to put the fields filtered as sheet filters for the Dimensions in the rows. I can do that, but I can't slect the "Wildcard Match" filter. This are the options for the filter by action:

      And this are the filter options for the same Dimension, for a normal filter:

      I attach an example workbook, thanks for your help.

        • 1. Re: Wildcard Match for Action Filters
          Joe Oppelt

          I just tried it.  I see the same thing.


          I suppose I can understand the reason for this.  An action filter is passing specific values to the target sheet, so the underlying engineering of that filter will behave with the expectation that specific values are how that filter should operate.  (We don't pass wildcard values in a filter action.)


          If you have a strong business need for wildcard behavior in this filter, you can post an IDEA on the IDEAS forum here:




          Be sure to include your business need if you post a request for this.  If you leave out the business need, you can expect someone is going to ask you for one, so you may as well have it right up front.  (I'm curious about what wildcards can do for you with respect to clearing the filter.)