9 Replies Latest reply on Sep 15, 2018 3:21 PM by Ken Flerlage

    Is there a way to override my worksheet with a blank sheet when filter - All value is selected and Shows the actual worksheet when any other value is selected.

    Monisha Ramesh

      Is there a way to override my worksheet with a blank sheet covering the text when "filter - All" value is selected and Shows the actual worksheet when any other value is selected.

       

      Note:

      Any calculations I have tried fail to recognize the "All" in the filter.

      And the filter has about 100+ entries so I would not want a parameter value created to blank out the worksheet instead.

       

      Any help on creating a blank worksheet to override one when "All" is selected would be helpful